Comments (6)
3noch
commented on August 16, 2024
It appears you already map CI Text to TEXT. I get decode errors when trying to use citext. How would I go about fixing that? I'm not sure I like having instances already defined for CI Text because they don't properly correlate to those semantics in the database, unless you use something like citext.
from beam.
3noch
commented on August 16, 2024
And now I see that I'm just wrong. postgresql-simple handles this as it should.
from beam.
3noch
commented on August 16, 2024
However, it seems there is no SQL-support typeclass that includes this.
from beam.
tathougies
commented on August 16, 2024
@3noch Can you clarify what you mean by 'SQL-support typeclass'?
from beam.
3noch
commented on August 16, 2024
Sorry. I mean GHC couldn't find a type class that had an instance for serializing / deserializing CI Text values.
from beam.
tathougies
commented on August 16, 2024
I've added these instances in beam-postgres. You should be able to find them in the latest master, or on hackage.
from beam.
Related Issues (20)
- Lens example in tutorial does not work HOT 1
- GHC 9.6 failures HOT 3
- beam-sqlite: No `instance HasSqlEqualityCheck Sqlite Day` HOT 1
- WHERE clauses are silently dropped if there is no FROM HOT 1
- beam-sqlite: support for `LIKE` + `ESCAPE` ? HOT 1
- free-5.2 not allowed
- vector-0.13 not allowed
- primitive-0.8 not allowed HOT 3
- How to get primary key type? HOT 1
- Subquery without aggregation
- Multicolumn aggregate HOT 1
- Is there any way to reuse a `ToField`, `FromField` definitions from sqlite-simple? HOT 1
- Precise type for `max_` aggregate function
- Postgres column doesn't roundtrip for type `Maybe (Vector Text)`
- Outdated dependencies HOT 4
- Passing `Double`s to `val_` sometimes leads to runtime errors
- run-time error "column t0.res0 does not exist" HOT 1
- Insert result of an insert
- Run-time error "window function first_value requires an OVER clause" HOT 1
- run-time error: operator does not exist: timestamp without time zone < text
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from beam.