Postgres Pro
Downloads
Home   >   mailing lists

contracting tables - Mailing list pgsql-sql

From Peter T. Brown
Subject contracting tables
Date
Msg-id 00e001c17930$aa8af8b0$7d00000a@PETER
Whole thread Raw
Responses Re: contracting tables  (Markus Bertheau <twanger@bluetwanger.de>)
Any available solution to port CONNECT BY of oracle to postgresql  (MindTerm <mindterm@yahoo.com>)
Re: contracting tables  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Re: contracting tables  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: PL/pgSQL loops?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Fixing faulty dates - select on day part of a date field