--- Brian Hurt <bhurt@janestcapital.com> wrote:
> Check for nulls. Remember that 'foo' || NULL yeilds NULL, so if one of
> your fields is null, the whole string will be null.
Also, if you know the nulls will be present, and you want a way to handle them is a predetermined
way, you can wrap your fields like so: COALESCE( yourfield, 'oops value is null') or some such.
http://www.postgresql.org/docs/8.2/interactive/functions-conditional.html#AEN13107
I hope this helps.
Regards,
Richard Broersma Jr.