Re: concat fails 'sometimes' on empty colums in select

On Sat, Dec 11, 2004 at 03:33:07 +0100,
  Stefan de Konink <skinkie@xs4all.nl> wrote:
> Hi,
>
> I have a table with some empty colums, if I try to concat my colums to
> eachother something strange happens. Rather empty column B produces
> virtually no output using the || in the select query. But the half filed
> colum A does give the desired output.

Empty strings and NULL values aren't the same thing. You probably either
want to store empty strings or use coalesce to change NULL to an empty
string before using concatenation, as a NULL concatenated with anything
results in NULL.