From: Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: Eric Veldhuyzen <ericv@xs4all.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: cast of integer to bool doesn't work (anymore?)
Date: Fri, 21 Mar 2003 15:54:56 -0200 (GMT+2)
Message-ID: <Pine.LNX.4.44.0303211553560.2751-100000@matrix.gatewaynet.com> (raw)
In-Reply-To: <20030321133646.GC6540@opium.xs4all.nl>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: achill@matrix.gatewaynet.com, ericv@xs4all.net
Subject: Re: cast of integer to bool doesn't work (anymore?)
In-Reply-To: <Pine.LNX.4.44.0303211553560.2751-100000@matrix.gatewaynet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox