Boolean

Started by Bamberoover 21 years ago2 messagesgeneral
Jump to latest
#1Bambero
bambero@tlen.pl

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

#2Thomas F.O'Connell
tfo@sitening.com
In reply to: Bambero (#1)
Re: Boolean

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:

Show quoted text

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