Re: Authorizing select count() - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Authorizing select count()
Date
Msg-id 2069464.1653528458@sss.pgh.pa.us
Whole thread Raw
In response to Re: Authorizing select count()  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Authorizing select count()
List pgsql-hackers
Michael Paquier <michael@paquier.xyz> writes:
> On Wed, May 25, 2022 at 12:26:47PM +0200, Laetitia Avrot wrote:
>> You will find enclosed a patch proposal to allow count to be used without a
>> star. I, on purpose, decided not to document this behavior, maybe that's
>> wrong.

> This originates from 108fe47, most likely as part of this thread.

I'm fairly sure that in the past we've considered this idea and rejected
it, mainly on the grounds that it's a completely gratuitous departure
from SQL standard.  I quite agree that the syntax without star would be
saner, but once we get into inventing "saner" variants of SQL syntax,
where do we stop?  And how much are we buying really?

I definitely don't agree with doing it but not documenting it; that
will just result in endless confusion.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [RFC] Improving multi-column filter cardinality estimation using MCVs and HyperLogLog
Next
From: Amit Langote
Date:
Subject: Re: First draft of the PG 15 release notes