Count(*) Question

Поиск
Список
Период
Сортировка
От Peter Darley
Тема Count(*) Question
Дата
Msg-id NNEAICKPNOGDBHNCEDCPEECJCIAA.pdarley@kinesis-cem.com
обсуждение исходный текст
Ответы Re: Count(*) Question  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Count(*) Question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Kym Farnik"
Дата:
Сообщение: Re: What popular, large commercial websites run PostgreSQL?
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Count(*) Question