Thread: Boolean to Integer?
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
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) >
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