Re: [HACKERS] Another optimizer question

[Dennis Haney]

Bruno Wolff III wrote: On Tue, Jan 27, 2004 at 17:27:25 +0100, Dennis Haney <[EMAIL PROTECTED]> wrote: Is it just me, or is there any way a sort could be relevant in a subquery? (except on queries containing volatile functions) Yes. It is important when a limit or distinct on clause is used in a subquery. Yup, but queries with those are also ignored, so I'm only talking about explicit 'order by' without any fancy stuff ;) -- Dennis