I have a function that takes two text parameters. If both of these
are non-null, everything works fine. However, if one of these two
parameters is null and one is not, the function receives both as null.
CREATE FUNCTION F(TEXT,TEXT) RETURNS TEXT AS '
BEGIN
RETURN $2;
END;
' LANGUAGE 'plpgsql';
SELECT F(null,'Hello');
returns null.
Is this intentional? Is there a way around this?
--
Joel Burton, Director of Information Systems -*- jburton(at)scw(dot)org
Support Center of Washington (www.scw.org)