Re: Count(*) Question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Joel Burton" <joel(at)joelburton(dot)com>
Cc: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, "Peter Darley" <pdarley(at)kinesis-cem(dot)com>, "Pgsql-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Count(*) Question
Date: 2002-05-01 17:57:11
Message-ID: 10468.1020275831@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Joel Burton" <joel(at)joelburton(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dorian dorian 2002-05-01 18:49:55 Re: icps, shmmax and shmall - Shared Memory tuning
Previous Message Marc G. Fournier 2002-05-01 17:51:18 Re: [GENERAL] Fwd: Postfix Relay Hub SMTP server: errors from