select case when boolfield = true then 1 else 0 end as boolint
from booltable
>>> Philip Hallstrom <philip@adhesivemedia.com> 10/17/02 10:09AM >>>
Search the manual for "CASE" I can never remember the syntax, but that's
what you want... it's behaves similar to a C switch statement.
On Thu, 17 Oct 2002, Roberto (SmartBit) wrote:
> Hi all
>
> How could i transform a Boolean value in a Integer???
>
> My table field is Boolean, but I'd like that my SELECT reults an Integer
> field!!
>
> something like: SELECT IF( FieldBoolName , 1, 0) FROM myTABLE
>
>
> tia
>
>
> Roberto de Amorim - +55 48 346-2243
> Software engineer at SmartBit Software
> Delphi and Interbase consultant
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster