Kirk Wythers <kwythers@umn.edu> writes:
> On Feb 2, 2007, at 7:39 PM, Luke Lonergan wrote:
>> 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.
Er ... then why are you SELECTing the data at all? You can most likely
get it done much faster if the data stays inside the database engine.
regards, tom lane