On Fri, 12 Aug 2011, David Johnston wrote:
Thus, you need to replace the "*" in the SELECT with the specific columns that correspond to the columns listed in to INSERT portion of the query.
David, Mea culpa! I should have seen this myself. Now the query works and I have about 6K duplicate pairs to fix. Thanks, Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
