http://www.postgresql.org/docs/7.4/static/datatype-boolean.html
CASE WHEN its THEN 'true' ELSE 'false' END
-tfo
On Oct 14, 2004, at 3:43 PM, Bambero wrote:
Postgres returns me 't' or 'f' from boolean field
How to change that it returns me 'true' or 'false'
replace(its, 'f', 'false') AS its
doesn't work
Bambero
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org