Re: Forcing a specific order

Martin Foster <martin@ethereal-realms.org> writes:
> I should have been a bit more clear on the matter.   Order by is useful
> if you want to sort the dataset a specific way using rows.  However,
> what if I wanted to specify the order the rows are returned in using
> information from another query?

This sounds like you are trying to force a join order, not a specific
tuple order.  Have you read the material about join ordering in the
performance-tips chapter?

            regards, tom lane