Re: [HACKERS] libpq: why we need to fetch all rows?

>
> On Sun, 29 Jun 1997, Bruce Momjian wrote:
>
> > > statements. A lookup table of portals/cursors and their corresponding Oid
> > > tables could be maintained by the server.
> >
> > The problem is that most results are joins, and there are multiple oid's
> > to deal with .
>
> In this case couldn't you create a temporary table and return the name
> of the table to the client?  It could then "cursor" through the temporary
> table.

Yes, we could, but you would not want to do that all the time because of
performance.  You would have to determine if that particulary select
statement was going to need it.

- --
Bruce Momjian
maillist@candle.pha.pa.us

------------------------------