[Haskell-cafe] Takusen, postgres and boolean fields
Sasha Shipka
xaotuk at gmail.com
Fri Apr 24 18:17:22 EDT 2009
Let say one has to do something similar to this:
execDML $ cmdbind (sql "update some_table set some_boolean_field = ?
where ...") [bindP True, ...]
When I do it, I have an error:
DBError ("42","804") 7 "ERROR: 42804: column \"some_boolean_field\"
is of type boolean but expression is of type text ..."
I've noticed that when I read boolean fields from postgres it reads
them as string "t" or "f". So I also tried bindP "t" and had same
error.
More information about the Haskell-Cafe
mailing list