On Monday, January 8, 2024, Geoff Winkless <pgsqlad...@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.