Hi,
I have currently trouble working with boolean values and variables in functions. As one would expect, a select '1'::bool, 't'::bool, 'true'::unknown::boolean works. As a select '1' tells us this seems as a conversion unknown->bool or ??maybe?? a boolean literal?? what-o-ever, at least my function gets not accepted: CREATE OR REPLACE FUNCTION testbool(varchar) RETURNS boolean AS $BODY$ SELECT $1::boolean $BODY$ LANGUAGE 'sql' STABLE STRICT SECURITY DEFINER; Postgres complains that it can't convert varchar to boolean. Actually neither $1::unknown::bool works. It turns out that there exists no conversion varchar/text/unknown -> boolean. Actually there's not any conversion -> boolean. How should this be treaten? *being confused* sorry for duplicating (I'm sure) this topic, at least I tried to find it in the listarcive. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
