Re: weird GROUPING SETS and ORDER BY behaviour - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: weird GROUPING SETS and ORDER BY behaviour
Date
Msg-id CAKFQuwZrbWzSiiL2wpY-+E4fOhZ9Fq0gsGS=MQxm6P9XajsYgQ@mail.gmail.com
Whole thread Raw
In response to Re: weird GROUPING SETS and ORDER BY behaviour  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-hackers
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.

pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: Escape output of pg_amcheck test
Next
From: Aleksander Alekseev
Date:
Subject: Re: Escape output of pg_amcheck test