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