Re: SELECT Field1 || Field2 FROM Table

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