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