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
Date: Fri, 03 Jun 2005 15:07:03 +0200
Message-ID: <1117804023.9816.30.camel@dicaprio.akademie1.de> (raw)
In-Reply-To: <Pine.LNX.4.44.0506031545230.23350-100000@matrix.gatewaynet.com>
References: <Pine.LNX.4.44.0506031545230.23350-100000@matrix.gatewaynet.com>
В Птн, 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.
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
In-Reply-To: <1117804023.9816.30.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