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/ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
