On Sat, Dec 11, 2004 at 01:54:35PM -0600, Bruno Wolff III wrote:
> 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.
To simplify this operation you could create an operator that does
the coalesce for you. This has come up recently; search the list
archives for examples.
In response to
pgsql-bugs by date
|Next:||From: Michael Fuhr||Date: 2004-12-12 01:55:57|
|Subject: Re: create/drop table bug|
|Previous:||From: Bruno Wolff III||Date: 2004-12-11 19:54:35|
|Subject: Re: concat fails 'sometimes' on empty colums in select|