This is relevant for tables that have a column with a SERIAL type, I need to guarantee that the relative ordering remains the same as the ordering of the selected result set.
The logical insertion order, and thus the sequence values, will be assigned according to the order by.
David J.
