Boolean to Integer?

From: "Roberto (SmartBit)" <roberto(at)smartbit(dot)inf(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Boolean to Integer?
Date: 2002-10-17 17:03:57
Message-ID: 004001c275ff$344850e0$1501a8c0@NoteBook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Hallstrom 2002-10-17 17:09:17 Re: Boolean to Integer?
Previous Message pginfo 2002-10-17 16:23:22 Query performance with small data base