Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id 156894758F2 for ; Wed, 27 Feb 2002 01:32:21 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g1R6BjT56650 for pgsql-sql@postgresql.org; Wed, 27 Feb 2002 00:11:45 -0600 (CST) (envelope-from news) From: Edward Murray X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Left Outer Join Question Date: Wed, 27 Feb 2002 17:09:50 +1100 Organization: Avenue Network Services Lines: 18 Message-ID: References: <20158.1014789326@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: news@hub.org User-Agent: Pan/0.11.2 (Unix) X-Comment-To: "Tom Lane" To: pgsql-sql@postgresql.org X-Archive-Number: 200202/421 X-Sequence-Number: 6842 On Wed, 27 Feb 2002 16:59:23 +1100, Tom Lane wrote: > "Christopher Kings-Lynne" writes: >> What's probably happening is that count isn't counting NULLs? > > As per spec. If you want to count records independently of whether any > particular column is NULL or not, use count(*). See the docs, notably > http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/sql-expressions.html#SYNTAX-AGGREGATES I think the problem is that the rows are not being returned by the query at all not that any particular column is null. Do I need to perform another outer join? I am not sure how to tackle this problem. > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org