Count(*) Question - Mailing list pgsql-general

From Peter Darley
Subject Count(*) Question
Date
Msg-id NNEAICKPNOGDBHNCEDCPEECJCIAA.pdarley@kinesis-cem.com
Whole thread Raw
Responses Re: Count(*) Question
Re: Count(*) Question
List 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


pgsql-general by date:

Previous
From: "Kym Farnik"
Date:
Subject: Re: What popular, large commercial websites run PostgreSQL?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Count(*) Question