Postgres Pro
Downloads
Home   >   mailing lists

Re: Use true and false when bulk-exporting boolean data - Mailing list pgsql-general

From Henry Drexler
Subject Re: Use true and false when bulk-exporting boolean data
Date
Msg-id CAAtgU9SSHEZ4TG4Qz1+4heUaGkiK=6xqbg04+e_KVpULqWQ5hw@mail.gmail.com
Whole thread Raw
In response to Re: Use true and false when bulk-exporting boolean data  (Henry Drexler <alonup8tb@gmail.com>)
List pgsql-general
Tree view


On Mon, Oct 17, 2011 at 3:11 PM, Henry Drexler <alonup8tb@gmail.com> wrote:
couldn't you just wrap it in a case statement to change the t to true etc...?


example:  

select
case when (1=1) = true then 'true' else 'false' end 

pgsql-general by date:

Previous
From: Henry Drexler
Date:
Subject: Re: Use true and false when bulk-exporting boolean data
Next
From: David Salisbury
Date:
Subject: Re: exclusive OR possible within a where clause?