Re: concatenating with NULLs - Mailing list pgsql-general

On 04/25/2011 02:13 PM, 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.


SELECT 'a' || 'b' || coalesce(NULL, '');