From: Markus Bertheau ☭ <twanger@bluetwanger.de>
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: Michael Glaesemann <grzm@myrealbox.com>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: 'true'::TEXT::BOOLEAN doesn't work
Date: Fri, 03 Jun 2005 15:43:59 +0200
Message-ID: <1117806239.9816.39.camel@dicaprio.akademie1.de> (raw)
In-Reply-To: <1117804023.9816.30.camel@dicaprio.akademie1.de>
References: <Pine.LNX.4.44.0506031545230.23350-100000@matrix.gatewaynet.com>
<1117804023.9816.30.camel@dicaprio.akademie1.de>
В Птн, 03/06/2005 в 15:07 +0200, Markus Bertheau ☭ пишет:
> В Птн, 03/06/2005 в 15:46 +0300, Achilleus Mantzios пишет:
>
> > Also according to the docs:
> > http://www.postgresql.org/docs/current/static/datatype-boolean.html
> >
> > "Tip: Values of the boolean type cannot be cast directly to other types
> > (e.g., CAST (boolval AS integer) does not work). This can be accomplished
> > using the CASE expression: CASE WHEN boolval THEN 'value if true' ELSE
> > 'value if false' END."
>
> Ah, that works. Thanks very much.
Correcting myself, that doesn't work. It says something along the lines
of case expression must be of type boolean.
Markus
--
Markus Bertheau ☭ <twanger@bluetwanger.de>
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: twanger@bluetwanger.de, achill@matrix.gatewaynet.com, grzm@myrealbox.com
Subject: Re: 'true'::TEXT::BOOLEAN doesn't work
In-Reply-To: <1117806239.9816.39.camel@dicaprio.akademie1.de>
* 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