Parsing `interval` into `CalendarDiffTime` fails in `PostgreSQL`

tomjaguarpaw / haskell-opaleye

Other

602 stars 115 forks source link

Parsing `interval` into `CalendarDiffTime` fails in `PostgreSQL` #601

Open tysonzero opened 3 months ago

tysonzero commented 3 months ago

I get a ConversionFailed exception with:

errSQLType = "interval"
errHaskellType = "CalendarDiffTime"

and a few different possible error messages depending on the value:

errMessage = "Failed reading: no parse of \"00:00:00\""
errMessage = "Failed reading: no parse of \"00:00:01\""
errMessage = "Failed reading: no parse of \"1 mon\""

Note that writing seems to work just fine, I was able to insert the above rows without issue, I just can't selectTable them back.

tysonzero commented 3 months ago

Ah oops I just read the note, works fine with intervalstyle configured appropriately. Could still be nice to not require that setting change, although from following the code it seems like the parsing code lives in postgresql-simple anyway. Feel free to close.