Received: from web20809.mail.yahoo.com (web20809.mail.yahoo.com [216.136.226.198]) by postgresql.org (8.11.3/8.11.4) with SMTP id fAUFjWm93004 for ; Fri, 30 Nov 2001 10:45:32 -0500 (EST) (envelope-from jeff_eckermann@yahoo.com) Message-ID: <20011130154536.41315.qmail@web20809.mail.yahoo.com> Received: from [65.11.165.34] by web20809.mail.yahoo.com via HTTP; Fri, 30 Nov 2001 07:45:36 PST Date: Fri, 30 Nov 2001 07:45:36 -0800 (PST) From: Jeff Eckermann Subject: Re: contracting tables To: "Peter T. Brown" , pgsql-sql@postgresql.org In-Reply-To: <00e001c17930$aa8af8b0$7d00000a@PETER> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200111/438 X-Sequence-Number: 5819 Thinking about that some more: SELECT INTO table2 DISTINCT * FROM table1; TRUNCATE table1; INSERT INTO table1 SELECT * FROM table2; DROP TABLE2; may be easiest, if you want to preserve table1, and need distinct row values. --- "Peter T. Brown" wrote: > 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 > > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please > send an appropriate > subscribe-nomail command to majordomo@postgresql.org > so that your > message can get through to the mailing list cleanly __________________________________________________ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1