Kirk Wythers wrote: > > On Feb 2, 2007, at 8:32 PM, Tom Lane wrote: > >> Kirk Wythers <[EMAIL PROTECTED]> 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.
INSERT INTO foo SELECT * FROM BAR JOIN baz USING (id) Joshua D. Drake > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
