On Feb 2, 2007, at 7:39 PM, Luke Lonergan wrote:
Tom,
On 2/2/07 2:18 PM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote:
as of 8.2 there's a psql variable
FETCH_COUNT that can be set to make it happen behind the scenes.)
FETCH_COUNT is a godsend and works beautifully for exactly this
purpose.
Now he's got to worry about how to page through 8GB of results in
something
less than geological time with the space bar ;-)
I actually have no intention of paging through the results, but
rather need to use the query to get the results into a new table with
UPDATE, so that a GIS system can do some interpolations with subsets
of the results.
- Luke
