Re: Boolean

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Bambero <bambero(at)tlen(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Boolean
Date: 2004-10-14 21:01:51
Message-ID: 4564DE7A-1E24-11D9-AB8E-000D93AE0944@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

  • Boolean at 2004-10-14 20:43:44 from Bambero

Browse pgsql-general by date

  From Date Subject
Next Message Andre Maasikas 2004-10-14 21:02:56 Re: Count Issues
Previous Message Michael Holden 2004-10-14 21:00:51 Possibly stupid questions re: large tables/files, port 5432 access