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