Jack Flak <[EMAIL PROTECTED]> writes: > So, once again, here's my question: how do I go about deleting the > duplicate entries WITHOUT also deleting the originals?
Perhaps something like
CREATE TABLE foo AS SELECT DISTINCT * FROM original;
then delete all from original, then INSERT INTO original SELECT * FROM foo;
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
