Re: 'true'::TEXT::BOOLEAN

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