Home > mailing lists

contracting tables - Mailing list pgsql-sql

From	Peter T. Brown
Subject	contracting tables
Date	November 29, 2001 22:04:28
Msg-id	00e001c17930$aa8af8b0$7d00000a@PETER Whole thread Raw
Responses	Re: contracting tables Any available solution to port CONNECT BY of oracle to postgresql Re: contracting tables Re: contracting tables
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:

From: Tom Lane
Date: 29 November 2001, 21:25:15
Subject: Re: PL/pgSQL loops?

From: "Christopher Kings-Lynne"
Date: 29 November 2001, 23:34:28
Subject: Re: Fixing faulty dates - select on day part of a date field

contracting tables - Mailing list pgsql-sql

Previous

Next