Postgres Pro
Downloads
Home   >   mailing lists

Boolean to Integer? - Mailing list pgsql-general

From Roberto (SmartBit)
Subject Boolean to Integer?
Date
Msg-id 004001c275ff$344850e0$1501a8c0@NoteBook
Whole thread Raw
Responses Re: Boolean to Integer?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Shane Wright
Date:
Subject: Re: PostgreSQL query failed: COPY state must be terminated first
Next
From: Philip Hallstrom
Date:
Subject: Re: Boolean to Integer?