Daniel Schuchardt <d.schuchardt@xxxxxxxxxxxxx> writes: > CREATE OR REPLACE FUNCTION show_transform_problem(with_transform BOOL) > RETURNS BOOL AS $$ > DECLARE result BOOL; > BEGIN > IF with_transform THEN > SET transform_null_equals TO ON; > END IF; > RESULT:=NULL=1; > SET transform_null_equals TO OFF; > RETURN result; > END $$ LANGUAGE plpgsql; That isn't going to work unless you EXECUTE the target statement, so that it's re-parsed from scratch every time. It's highly unlikely that transform_null_equals will solve your problem anyway. Find a more standards-compliant way. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
