Subject: Re: 'true'::TEXT::BOOLEAN
From: Markus Bertheau =?UTF-8?Q?=E2=98=AD?= <twanger@bluetwanger.de>
To: Michael Glaesemann <grzm@myrealbox.com>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
In-Reply-To: <3DCEDE55-9D4A-4F4E-8907-ADCC058A3398@myrealbox.com>
References: <Pine.LNX.4.44.0506031420340.23350-100000@matrix.gatewaynet.com>
	<1117799555.9816.24.camel@dicaprio.akademie1.de>
	<3DCEDE55-9D4A-4F4E-8907-ADCC058A3398@myrealbox.com>
Content-Type: text/plain; charset=utf-8
Date: Fri, 03 Jun 2005 14:23:37 +0200
Message-Id: <1117801417.9816.28.camel@dicaprio.akademie1.de>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

This also bypasses the built in postgresql boolean literal parsing.

I think casting from text to boolean should be possible, and use the
same algorithm that's used when casting from "unknown" to boolean.

Markus

В Птн, 03/06/2005 в 21:14 +0900, Michael Glaesemann пишет:
> 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
-- 
Markus Bertheau ☭ <twanger@bluetwanger.de>