Re: problems with SELECT query results

[Richard Broersma Jr <rabroersma(at)yahoo(dot)com>]

--- Brian Hurt <bhurt(at)janestcapital(dot)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.