Quick Links

contracting tables

From:	"Peter T(dot) Brown" <peter(at)memeticsystems(dot)com>
To:	<pgsql-sql(at)postgresql(dot)org>
Subject:	contracting tables
Date:	2001-11-29 23:50:44
Message-ID:	00e001c17930$aa8af8b0$7d00000a@PETER
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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

Responses

Re: contracting tables at 2001-11-30 07:53:28 from Markus Bertheau
Any available solution to port CONNECT BY of oracle to postgresql at 2001-11-30 10:20:51 from MindTerm
Re: contracting tables at 2001-11-30 15:38:54 from Jeff Eckermann
Re: contracting tables at 2001-11-30 15:45:36 from Jeff Eckermann

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Christopher Kings-Lynne	2001-11-30 01:34:33	Re: Fixing faulty dates - select on day part of a date field
Previous Message	Ligia Pimentel	2001-11-29 23:22:22	An easy question about creating a primary key