Received: from typhoon.mail.pipex.net (typhoon.mail.pipex.net [158.43.128.27]) by hub.org (8.9.3/8.9.3) with SMTP id LAA59611 for ; Tue, 7 Dec 1999 11:46:38 -0500 (EST) (envelope-from paul.ganney@dial.pipex.com) Received: (qmail 25224 invoked from network); 7 Dec 1999 16:46:36 -0000 Received: from useri013.uk.uudial.com (HELO ) (194.69.104.131) by smtp.dial.pipex.com with SMTP; 7 Dec 1999 16:46:36 -0000 Message-ID: <384D39E6.6459@dial.pipex.com> Date: Tue, 07 Dec 1999 16:46:30 +0000 From: "Paul S. Ganney" X-Mailer: Mozilla 2.02 (Win95; I; 16bit) MIME-Version: 1.0 To: pgsql-interfaces@postgreSQL.org Subject: Deleting duplicate records Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit This probably sounds horribly trivial, but still... I've managed to get some duplicate records in a table and am having problems getting rid of them (as there's nothing unique to SELECT on). Any ideas? And whilst I'm at it - any ideas on a scheme for preventing duplicates? Paul. -- ------------------------------------------- Expressed opinions are usually my own. Especially if they're any good (of course). -------------------------------------------