Skip site navigation (1) Skip section navigation (2)

ORDER BY on INTERSECT

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: ORDER BY on INTERSECT
Date: 2000-10-14 11:06:29
Message-ID: 200010141106.e9EB6TH30889@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Petr Splichal (xsplich(at)fi(dot)muni(dot)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


Responses

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2000-10-14 15:55:34
Subject: Re: PostgreSQL BugTool Submission
Previous:From: Bruce MomjianDate: 2000-10-14 04:36:46
Subject: Re: PostgreSQL BugTool Submission

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group