ORDER BY and LIMIT questions in EXCEPTs
От | Doug Fields |
---|---|
Тема | ORDER BY and LIMIT questions in EXCEPTs |
Дата | |
Msg-id | 5.1.0.14.2.20021008140639.0292f850@pop.pexicom.com обсуждение исходный текст |
Ответы |
Re: ORDER BY and LIMIT questions in EXCEPTs
|
Список | pgsql-general |
Hello, I have questions about how ORDER BY and LIMIT work with "EXCEPT" joined queries. Let's say I have a query like: SELECT * FROM something WHERE ... ORDER BY field EXCEPT SELECT * FROM something WHERE ... (It's much faster than a self-join per my tests!) Will the final output retain the order as specified by the "ORDER BY field" clause? Second question. Let's say I have a query like the above, but I insert a "LIMIT limit OFFSET offset" clause. If I put the clause in the first SELECT (before the EXCEPT), then I expect that the number of records returned will be at most "limit" and possibly less due to the EXCEPT. Correct? If I put the "LIMIT limit OFFSET offset" after the second SELECT, does it apply to the whole integrated query, or just to the second SELECT clause? Do I need to make this a subselect to make it apply to the whole query? example: SELECT * FROM ( SELECT * FROM something WHERE ... ORDER BY field EXCEPT SELECT * FROM something WHERE ... ) AS a LIMIT limit OFFSET offset Many thanks, Doug
В списке pgsql-general по дате отправления: