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

From Tom Lane
Subject Re: Authorizing select count()
Date
Msg-id 2121518.1653542837@sss.pgh.pa.us
Whole thread Raw
In response to Re: Authorizing select count()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
I wrote:
> 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.

After some more digging I found the thread that (I think) the "mere
pedantry" comment was referring to:

https://www.postgresql.org/message-id/flat/Pine.LNX.4.44.0604131644260.20730-100000%40lnfm1.sai.msu.ru

There's other nearby discussion at

https://www.postgresql.org/message-id/flat/4476BABD.4080100%40zigo.dhs.org

(note that that's referring to the klugy state of affairs before 108fe4730)

Of course, that's just a couple of offhand email threads, which should
not be mistaken for graven stone tablets.  But I still don't see much
advantage in deviating from the SQL-standard syntax for COUNT(*).

            regards, tom lane



pgsql-hackers by date:

Previous
From: Gurjeet Singh
Date:
Subject: Re: Patch: Don't set LoadedSSL unless secure_initialize succeeds
Next
From: Peter Smith
Date:
Subject: Re: Handle infinite recursion in logical replication setup