Re: Concatenation containing a "null" term - Mailing list pgsql-novice

On Sun, May 28, 2006 at 05:17:12PM -0400, Pierre Thibaudeau wrote:
> Is there a way of having the null-strings terms of the concatenation
> operator be considered as empty strings instead?

Use COALESCE.  Some people create a custom concatenation operator
that automatically does so.

http://www.postgresql.org/docs/8.1/interactive/functions-conditional.html#AEN12639
http://www.postgresql.org/docs/8.1/interactive/sql-createoperator.html

--
Michael Fuhr