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

On Tue, Jun 28, 2016 at 2:52 PM, Rushabh Lathia
<rushabh.lathia@gmail.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