On Tue, Jun 28, 2016 at 2:52 PM, Rushabh Lathia <rushabh.lat...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers