Daniel Schuchardt <[email protected]> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
