>
> Not necessarily. A join could produce some sort of temporary table (disk
> based or in memory) and each row produced by the join assigned an Oid.
True, in fact, I am working on the sort code now. However, if there is
an order by, you have to get all the rows and sort them, before
returning any of them. How many of these queries don't have an order
by? Usually most multi-row results have one.
- --
Bruce Momjian
maillist@candle.pha.pa.us
------------------------------