Postgres Pro
Downloads
Home   >   mailing lists

Column Alias Not Allowed In Grouping Function - Mailing list pgsql-www

From Vivek Suraiya
Subject Column Alias Not Allowed In Grouping Function
Date
Msg-id 401489932.1675199.1660656779333@mail.yahoo.com
Whole thread Raw
Responses Re: Column Alias Not Allowed In Grouping Function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-www
Tree view
Suppose we have a table SALES with the following columns:
cust_name
sales_person_name
sale_amt

then the SQL command:

SELECT cust_name c , sales_person_name s , SUM(sale_amt) , GROUPING(c , s) grp
FROM SALES
GROUP BY CUBE(c,s)
ORDER BY grp;

will fail. But, 

SELECT cust_name c , sales_person_name s , SUM(sale_amt) , GROUPING( cust_name , sales_person_name)  grp
FROM SALES
GROUP BY CUBE(c,s)
ORDER BY grp;

will succeed.

Why is it illegal to use the column aliases in the GROUPING function?


pgsql-www by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: UPSERT as a table name is confusing
Next
From: Tom Lane
Date:
Subject: Re: Column Alias Not Allowed In Grouping Function