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@matrix.gatewaynet.com       mantzios@softlab.ece.ntua.gr