Обсуждение: ORDER BY on INTERSECT
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
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