Count(*) Question

From: "Peter Darley" <pdarley(at)kinesis-cem(dot)com>
To: "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Count(*) Question
Date: 2002-04-30 23:45:33
Message-ID: NNEAICKPNOGDBHNCEDCPEECJCIAA.pdarley@kinesis-cem.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Friends,
I was reading through the Rules section of the online docs, and noticed the
following note: (* is just an abbreviation for all the attribute names of a
relation. It is expanded by the parser into the individual attributes, so
the rule system never sees it.)
Does this mean that count(*) may return less than the total number of
records if all the fields in a record are NULL?
If this is true, is there a better way to get a count of records?

Thanks,
Peter Darley

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-05-01 00:06:56 Re: Count(*) Question
Previous Message Kym Farnik 2002-04-30 23:42:29 Re: What popular, large commercial websites run PostgreSQL?