Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id D89A4475CE1 for ; Wed, 27 Feb 2002 00:55:35 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g1R5tQS20161; Wed, 27 Feb 2002 00:55:26 -0500 (EST) To: "Christopher Kings-Lynne" Cc: "Edward Murray" , pgsql-sql@postgresql.org Subject: Re: Left Outer Join Question In-reply-to: References: Comments: In-reply-to "Christopher Kings-Lynne" message dated "Wed, 27 Feb 2002 13:23:56 +0800" Date: Wed, 27 Feb 2002 00:55:26 -0500 Message-ID: <20158.1014789326@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200202/417 X-Sequence-Number: 6839 "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 regards, tom lane