Thread: Boolean

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

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