Re: Needed function IF(expr, expr, expr)

--- Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> Marek Lewczuk writes:


> Also note that in PostgreSQL there is a boolean
> type, and 0 and 1 are not
> valid boolean values.
>

Sort of:

jeff=# select 1 = true;
ERROR: Unable to identify an operator '=' for types
'integer' and 'boolean'
You will have to retype this query using an
explicit cast
jeff=# select '1' = true;
?column?
----------
t
(1 row)

jeff=# select version();
version

---------------------------------------------------------------------
PostgreSQL 7.3.1 on i386-portbld-freebsd4.7, compiled
by GCC 2.95.4
(1 row)

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com