--- Peter Eisentraut <peter_e@gmx.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