| From: | Philip Hallstrom <philip(at)adhesivemedia(dot)com> |
|---|---|
| To: | "Roberto (SmartBit)" <roberto(at)smartbit(dot)inf(dot)br> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Boolean to Integer? |
| Date: | 2002-10-17 17:09:17 |
| Message-ID: | 20021017100833.I82228-100000@cypress.adhesivemedia.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2002-10-17 17:23:40 | Re: Boolean to Integer? |
| Previous Message | Roberto (SmartBit) | 2002-10-17 17:03:57 | Boolean to Integer? |