From: Michael Glaesemann <grzm@myrealbox.com>
To: Markus Bertheau ☭ <twanger@bluetwanger.de>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: 'true'::TEXT::BOOLEAN
Date: Fri, 3 Jun 2005 21:14:18 +0900
Message-ID: <3DCEDE55-9D4A-4F4E-8907-ADCC058A3398@myrealbox.com> (raw)
In-Reply-To: <1117799555.9816.24.camel@dicaprio.akademie1.de>
References: <Pine.LNX.4.44.0506031420340.23350-100000@matrix.gatewaynet.com>
<1117799555.9816.24.camel@dicaprio.akademie1.de>
On Jun 3, 2005, at 8:52 PM, Markus Bertheau ☭ wrote:
> And I can't call it with a TEXT variable, because casting from TEXT to
> BOOLEAN isn't possible.
I'd be surprised if there weren't a some way to coerce the cast from
text to boolean, but you might want to just make a simple convenience
function in the interim:
test=# create or replace function text2bool (text)
returns boolean language sql as $$
select case
when lower($1) = 'true'
then true
else false
end;
$$;
CREATE FUNCTION
test=# select text2bool('true');
text2bool
-----------
t
(1 row)
test=# select text2bool('false');
text2bool
-----------
f
(1 row)
Just an idea.
Michael Glaesemann
grzm myrealbox com
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: grzm@myrealbox.com, twanger@bluetwanger.de
Subject: Re: 'true'::TEXT::BOOLEAN
In-Reply-To: <3DCEDE55-9D4A-4F4E-8907-ADCC058A3398@myrealbox.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