Seb wrote: > A query such as: > > SELECT 'a' || 'b' || NULL; > > returns a NULL. How can I ensure I get 'ab' in the result? I'm trying > to concatenate columns and one of them might have NULL values, which I > simply want to ignore. COALESCE is your friend: select 'a' || 'b' || COALESCE(columnName, ''); HTH Bosco. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
