Thread: Boolean to Integer?

Boolean to Integer?

From
"Roberto (SmartBit)"
Date:
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


Re: Boolean to Integer?

From
Philip Hallstrom
Date:
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)
>


Re: Boolean to Integer?

From
"Ian Harding"
Date:
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