Postgres Pro
Downloads
Home   >   mailing lists

Re: Left Outer Join Question - Mailing list pgsql-sql

From Tom Lane
Subject Re: Left Outer Join Question
Date
Msg-id 20158.1014789326@sss.pgh.pa.us
Whole thread Raw
In response to Re: Left Outer Join Question  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: Left Outer Join Question  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-sql
Tree view 
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> 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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Timestamp output
Next
From: "grep"
Date:
Subject: Bad design or SQL statment quandary