On Mon, Nov 08, 2004 at 04:54:40AM -0800, Stephan Szabo wrote: > > If I have a subselect with an ORDER BY, and I LEFT JOIN the result with the > > other table, is the order maintained? Or is PostgreSQL free to return the > > rows in any order, after the join? > > AFAIK, you have no guarantees as to the output order unless you have another > order by. The join may destroy the ordering, so even if you get the ordering > you want right now, you shouldn't rely on it.
OK. Thanks for the reply. Morten -- Morten K. Poulsen <[EMAIL PROTECTED]> http://www.afdelingp.dk/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
