Re: problems with SELECT query results

Joshua wrote:
> Thank you all for your assistance. I did end up finding NULL in the
> 'onorder' column which should have been zero's.... this was in a test
> table that happened to have some NULL in it for one reason or another
> but I should not find this in the production version of the table.
>
> I also appreciate you pointing out the COALESCE function. I will find
> that helpful in future work.
>
> I look forward to hopefully assisting you guys with some of your
> PostgreSQL dilemmas in the future!

Please do not top-post, and be sure to acknowledge both groups to whom you
multi-posted, pgsql.sql and pgsql.general, for their help.  (I don't know if
there were others.)

A more effective way to post to multiple groups is to cross-post, send to all
groups in the single message as I did here, which unifies the threads so that
all answers appear to each reader.

Multi-posting (sending to each group separately) is frustrating because it
fragments the conversation.

--
Lew