Re: problems with SELECT query results - Mailing list pgsql-novice

--- 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.