Re: trouble with a join on OS X

On Feb 2, 2007, at 8:32 PM, Tom Lane wrote:

> 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.
>
>

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.