On Feb 2, 2007, at 7:39 PM, Luke Lonergan wrote:
> Tom,
>
> On 2/2/07 2:18 PM, "Tom Lane" <tgl@sss.pgh.pa.us> 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
>
>