Tom Lane wrote:
> Martin Foster <martin(at)ethereal-realms(dot)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
Honestly no. Though I think I managed to find a quick solution for now
using a temporary table. This cuts down massively on the rows and
makes things pretty quick and slick overall.
I will however look at it, as it might explain why I was having
troubles. If the join could have taken place after rows were cut down,
things would have been more efficient!
Creator/Designer Ethereal Realms
In response to
pgsql-novice by date
|Next:||From: Cath Lawrence||Date: 2005-10-12 08:11:36|
|Subject: pg_hba.conf and ssl problem has me stumped|
|Previous:||From: Tom Lane||Date: 2005-10-12 02:34:40|
|Subject: Re: Forcing a specific order |