From: | Daniel Schuchardt <d(dot)schuchardt(at)prodat-sql(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Transform_Null_Equals does not work in Functions |
Date: | 2010-07-06 09:17:07 |
Message-ID: | i0usag$1bjp$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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_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;
SUNFLOWER=# SELECT show_transform_problem(false);
show_transform_problem
------------------------
(1 row)
SUNFLOWER=# SELECT show_transform_problem(true);
show_transform_problem
------------------------
(1 row)
SUNFLOWER=# SET transform_null_equals TO ON;
SET
SUNFLOWER=# SELECT null=1;
?column?
----------
f
(1 row)
--
Daniel Schuchardt
/Softwareentwicklung/
/http://www.prodat-sql.de/
From | Date | Subject | |
---|---|---|---|
Next Message | Davor J. | 2010-07-06 09:17:22 | psql \dp equivalent or similar query? |
Previous Message | GrGsM | 2010-07-06 07:06:06 | SQL Query Help Please ! |