Re: [GENERAL] Transform_Null_Equals does not work in Functions

2010-07-06 Thread Tom Lane
Daniel Schuchardt 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; > RETU

[GENERAL] Transform_Null_Equals does not work in Functions

2010-07-06 Thread Daniel Schuchardt
Hy Group, we use: PostgreSQL 9.0alpha4, compiled by Visual C++ build 1400, 32-bit and i tried to set Transform_null_equals in a Trigger to avoid a complex If Statement with many Coalesce, but it didnt work. You can try it easily with that example: CREATE OR REPLACE FUNCTION show_transform_