Postgres Pro
Downloads
Home   >   mailing lists

Thread: ORDER BY on INTERSECT

ORDER BY on INTERSECT

From
pgsql-bugs@postgresql.org
Date:
Petr Splichal (xsplich@fi.muni.cz) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
ORDER BY on INTERSECT

Long Description
I was not able to make an ORDER BY on INTERSECT of two SELECTs.
Instead I got this error:

] get_sortgroupclause_tle: ORDER/GROUP BY expression not found in
] targetlist

pg version:
PostgreSQL 7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66

have a nice day!

Sample Code
SELECT id from questions where id < 40 intersect select id from questions where id > 20 order by id;
ERROR:  get_sortgroupclause_tle: ORDER/GROUP BY expression not found in targetlist


No file was uploaded with this report

Re: ORDER BY on INTERSECT

From
Tom Lane
Date:
pgsql-bugs@postgresql.org writes:
> SELECT id from questions where id < 40 intersect select id from questions where id > 20 order by id;
> ERROR:  get_sortgroupclause_tle: ORDER/GROUP BY expression not found in targetlist

Already fixed in current sources, but thanks for the report.

            regards, tom lane