Hello Robert (Bob?),
Thank you for your answer. I will surely make a wide use the COALESCE
function in my scripts.
I also noticed the same behaviour in PL/pgSQL:
CREATE FUNCTION "xxxxxxxxxxxxxx" (text, text)
RETURNS text
AS 'BEGIN
RETURN $1 || ' ' || $2;
END;
'
LANGUAGE 'plpgsql'
Correct me if I am wrong:
It seems that a NULL value is not passed to the function ...
... or is it that a NULL value is not taken into account by PL/pgSQL.
Thank you all for the COALESCE trick.
Greetings from Jean-Michel POURE, Paris, France
pgAdmin development team
