Re: Count(*) Question - Mailing list pgsql-general

From Tom Lane
Subject Re: Count(*) Question
Date
Msg-id 10468.1020275831@sss.pgh.pa.us
Whole thread Raw
In response to Re: Count(*) Question  ("Joel Burton" <joel@joelburton.com>)
List pgsql-general
"Joel Burton" <joel@joelburton.com> writes:
> Interesting. In 7.3devel, it does not fail to count the completely-null rows
> in count(*). Does it actually do this for any version?

ISTR that back around 6.4 we had some problems with getting the
semantics of count(*) right ... but it's been quite awhile since
count(*) and count(1) weren't exactly the same thing.

            regards, tom lane

pgsql-general by date:

Previous
From: John Gray
Date:
Subject: Re: Fwd: Postfix Relay Hub SMTP server: errors from
Next
From: dorian dorian
Date:
Subject: Re: icps, shmmax and shmall - Shared Memory tuning