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