valderman / selda

A type-safe, high-level SQL library for Haskell
https://selda.link
MIT License
478 stars 58 forks source link

Sqlite and Psql disagree on the name "DOUBLE" - all uses cause broken Psql queries #162

Closed TomMD closed 3 years ago

TomMD commented 3 years ago

In psql it isn't called "DOUBLE" but "DOUBLE PRECISION". The term "DOUBLE" is hard-coded in the selda library (vs selda-postgres) which is going to make the fix a bit ugly, I think.

TomMD commented 3 years ago

There should be a simple solution after all - sqlite allows the psql name, per https://www.sqlite.org/datatype3.html