Greg Stark wrote:
> UNION ALL should still preserve the order of the subqueries. It just
> returns all the rows of each subquery one after the other with no
> other work.
Although without an ORDER BY that's not well-defined and thus not
guaranteed to work in future versions either. I doubt we're going to
change that anytime soon, but I wouldn't rely on it in an application.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com