From: | Paul Ramsey <pramsey(at)refractions(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Booleans and Casting |
Date: | 1999-02-12 22:17:02 |
Message-ID: | 36C4A85E.980EF852@refractions.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have the following SQL statement, which doesn't work (though I wish it
did):
select sum(value * ( plulabel = 'FO' )) from btmm group by gis_tag;
PG quite correctly complains that:
ERROR: There is more than one possible operator '*' for types
'float4' and 'bool' You will have to retype this query using an explicit
cast
However, when I do this:
select sum(value * int( plulabel = 'FO' )) from btmm group by gis_tag;
I still get an error:
ERROR: No such function 'int' with the specified attributes
I can find no function at all to use to cast booleans to what I want,
which is 1 = true, 0 = false (IE, the standard cast for boolean ->
number).
Any advice?
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey(at)refractions(dot)net
| Phone: (250) 885-0632
\_
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Doliov | 1999-02-13 03:22:24 | Re: Subject: Re: [GENERAL] A book for PgSQL? A need? yes? no? |
Previous Message | Simon Drabble | 1999-02-12 18:34:28 | Book recommendation |