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.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/