From: | "Luis Silva" <lfs12(at)hotmail(dot)com> |
---|---|
To: | mike(at)fuhr(dot)org |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: convert bool result query |
Date: | 2006-01-11 19:00:18 |
Message-ID: | BAY18-F74D71F6F26C6EDB24A249B5240@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
TKS a lot!!! It worked!!
>From: Michael Fuhr <mike(at)fuhr(dot)org>
>To: Luis Silva <lfs12(at)hotmail(dot)com>
>CC: pgsql-novice(at)postgresql(dot)org
>Subject: Re: [NOVICE] convert bool result query
>Date: Wed, 11 Jan 2006 11:57:09 -0700
>
>On Wed, Jan 11, 2006 at 06:41:38PM +0000, Luis Silva wrote:
> > I there!! How can I receive in my query result '1' or '0' instead of 't'
> > and 'f'. tks in advance
>
>In PostgreSQL 8.1 you can simply cast a boolean value to integer:
>
>test=> SELECT 't'::boolean::integer, 'f'::boolean::integer;
> int4 | int4
>------+------
> 1 | 0
>(1 row)
>
>In earlier versions you can create such a cast yourself or use a
>CASE expression:
>
>test=> SELECT CASE 't'::boolean WHEN true THEN 1 ELSE 0 END;
> case
>------
> 1
>(1 row)
>
>test=> SELECT CASE 'f'::boolean WHEN true THEN 1 ELSE 0 END;
> case
>------
> 0
>(1 row)
>
>--
>Michael Fuhr
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ford | 2006-01-11 19:06:53 | Removing duplicate entries |
Previous Message | Michael Fuhr | 2006-01-11 18:57:09 | Re: convert bool result query |