Received: from mail.memeticsystems.com (flywheel.memeticsystems.com [64.85.80.85]) by postgresql.org (8.11.3/8.11.4) with SMTP id fATNoim37647 for ; Thu, 29 Nov 2001 18:50:44 -0500 (EST) (envelope-from peter@memeticsystems.com) Received: (qmail 11367 invoked from network); 29 Nov 2001 23:50:46 -0000 Received: from unknown (HELO PETER) (63.249.24.21) by flywheel.memeticsystems.com with SMTP; 29 Nov 2001 23:50:46 -0000 From: "Peter T. Brown" To: Subject: contracting tables Date: Thu, 29 Nov 2001 15:50:44 -0800 Message-ID: <00e001c17930$aa8af8b0$7d00000a@PETER> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200111/424 X-Sequence-Number: 5806 Hi-- I have a table with many records, some of which are duplicates (there is no unique constraints). How can I contract this table to remove any of these duplicate records? Like when using GROUP BY in a select statement, except that I want to just remove the extra entries from this table directly... Any ideas? Thanks, Peter Brown