On Aug 21, 2007, at 12:04 AM, Tom Lane wrote:
If you need to deal with very large result sets, the standard advice is to use a cursor so you can pull a few hundred or thousand rows at a time via FETCH.
In case it's not obvious... in this case you might want to dump the output of that query into another table; perhaps a temp table...
CREATE TEMP TABLE dupe_check AS SELECT ... -- Decibel!, aka Jim Nasby decibel@xxxxxxxxxxx EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
