Re: Boolean to Integer?

select case when boolfield = true then 1 else 0 end as boolint
from booltable

>>> Philip Hallstrom <philip(at)adhesivemedia(dot)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(at)postgresql(dot)org)
>

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster