On Mon, Jun 09, 2003 at 10:35:10 +0200, Eivind Kvedalen <[EMAIL PROTECTED]> wrote: > > Ok. What I actually had in mind was whether the optimizer would remove the > ORDER BY clause completely or not, as it isn't used in the top-level > SELECT query, and SQL doesn't in general guarantee ordered rows back > unless there's an ORDER BY in the top-level SELECT (I haven't read the SQL > standard, so I might very well be wrong here).
Allowing ordering in subselects is a feature (mostly for use with LIMIT) and won't be removed because it isn't a top level select. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
