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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
