On Monday, January 8, 2024, Geoff Winkless <
pgsqladmin@geoff.dj> wrote
Mildly interesting: you can pass column positions to GROUP BY and
ORDER BY but if you try to pass a position to GROUPING() (I wondered
if that would help the engine somehow) it fails:
The symbol 1 is ambigious - it can be the number or a column reference. In a compound expression it is always the number, not the column reference.
David J.