On Feb 2, 2007, at 8:32 PM, Tom Lane wrote:
Kirk Wythers <kwythers@xxxxxxx> 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.
The new table needs to be filled with the results of the join. If
there is a way to do this without a SELECT, please share.
