Re: Submitting cursored query support, docs, etc

Hi!

2007/12/11, Dave Page <dpage(at)postgresql(dot)org>:
> I haven't looked at it in that much detail for a number of years
> unfortunately. However, from the top of my head, I would start by
> looking at ctlSQLResult::Execute/pgQueryThread::execute in which you can
> create the cursor and retrieve the first batch of results.

Yeah, that works fine; I have a button now that declares a cursor for
the user's query, and I can append 'fetch from' manually to actually
see a row :)

> Then, look at
> extending pgSet such that when run with a cursor, an attempt to access a
> row that hasn't be retrieved yet results in the dataset being extended
> before the value is returned. Currently pgSet is tied to a single
> PGResult, but I guess in cursor mode we would probably need to make that
> a list of PGResults each containing <= N rows where N is a configurable
> batch size.

This is exactly the kind of hint I hoped for. Thanks!

--
Kalle Hallivuori +358-41-5053073 http://korpiq.iki.fi/