"Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)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