Re: concenation of strings and null values

Hello

> SELECT 'abc'::text || null::text;
>
> The last example looks like a bug,
> but if it is intentionally so, its
> at least very annoying and inconvenient.

NULL means here UNKOWN. You cannot add or concatenate something to an
undefined Value.

Regards

Dieter