Re: ERROR: ORDER/GROUP BY expression not found in targetlist

On Tue, Jun 28, 2016 at 2:52 PM, Rushabh Lathia
<rushabh(dot)lathia(at)gmail(dot)com> wrote:
> Hi,
>
> Consider the below testcase:
>
> CREATE TABLE tab(
> c1 INT NOT NULL,
> c2 INT NOT NULL
> );
> INSERT INTO tab VALUES (1, 2);
> INSERT INTO tab VALUES (2, 1);
> INSERT INTO tab VALUES (1, 2);
>
>
> case 1:
>
> SELECT c.c1, c.c2 from tab C WHERE c.c2 = ANY (
> SELECT 1 FROM tab A WHERE a.c2 IN (
> SELECT 1 FROM tab B WHERE a.c1 = c.c1
> GROUP BY rollup(a.c1)
> )
> GROUP BY cube(c.c2)
> )
> GROUP BY grouping sets(c.c1, c.c2)
> ORDER BY 1, 2 DESC;
> ERROR: ORDER/GROUP BY expression not found in targetlist
>
> case 2:
>
> create sequence s;
> SELECT setval('s', max(100)) from tab;
> ERROR: ORDER/GROUP BY expression not found in targetlist

The following give the same error:

select max(100) from tab;
select max((select 1)) from tab;

Thanks,
Amit