Re: cast of integer to bool doesn't work (anymore?)

On Fri, 21 Mar 2003, Eric Veldhuyzen wrote:

> Hi,
>
> Here at my work we use on the production servers PostgreSQL version
> 7.2.3, but I have version 7.3.2 (from the Debian distribution) on my
> workstation. Now I noticed yesterday that the query 'select 0::boolean;'
> works on the production server, it gives the output:
>
> # select 0::boolean;
> bool
> ------
> f
> (1 row)
>
> Perfect. But when I try this on my local version of postgreSQL I get
> this:
>
> # select 0::boolean;
> ERROR: Cannot cast type integer to boolean

Just wrap 0 with single quotes,
e.g.
# select '0'::boolean;

>
> Is there someone who can axplaint to me why this is happening, did I
> forget to do something to make this work, or is this some kind of new
> 'feature' of the 7.3 version?
>
>

--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill(at)matrix(dot)gatewaynet(dot)com
mantzios(at)softlab(dot)ece(dot)ntua(dot)gr