pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Lew <lew@nospam.lewscanon.com>
To: pgsql-general@postgresql.org
Subject: Re: problems with SELECT query results
Date: Tue, 29 May 2007 15:33:53 -0400
Message-ID: <qv6dnWBN0OS8HcHbnZ2dnUVZ_sHinZ2d@comcast.com> (raw)
In-Reply-To: <465C6705.5000505@joshuaneil.com>
References: <465C4B0B.4070906@joshuaneil.com>
	<465C5671.50907@archonet.com>
	<465C6705.5000505@joshuaneil.com>

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



view thread (5+ messages)  latest in thread

Message-ID: <qv6dnWBN0OS8HcHbnZ2dnUVZ_sHinZ2d@comcast.com>
Permalink:  ../qv6dnWBN0OS8HcHbnZ2dnUVZ_sHinZ2d@comcast.com/
Also on:    postgresql.org/message-id/qv6dnWBN0OS8HcHbnZ2dnUVZ_sHinZ2d@comcast.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: lew@nospam.lewscanon.com, pgsql-general@postgresql.org
  Subject: Re: problems with SELECT query results
  In-Reply-To: <qv6dnWBN0OS8HcHbnZ2dnUVZ_sHinZ2d@comcast.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox