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@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)