Message-ID: <20050524175931.4dp41vy7v10c4wc4@www.presserv.org>
Date: Tue, 24 May 2005 17:59:31 -0300
From: lucas@presserv.org
To: pgsql-sql@postgresql.org
Subject: Duplicated records
MIME-Version: 1.0
Content-Type: text/plain;
	charset=ISO-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
User-Agent: Internet Messaging Program (IMP) H3 (4.0)

Hi.
How can I delete the duplicated records with "DELETE FROM TABLE WHERE..."
clause??
The problem is becouse I have imported data from Dbase (dbf) file, and this
function have not built the Constraint (unique, primary key, ...), and this
function is usually executed.

 select * from table1; --id may be primary key
 - Table1 -
 id | field 2
 0  | 'aaa'
 1  | 'bbb'
 2  | 'ccc'
 0  | 'aaa'  <<== The data is duplicated
 1  | 'bbb'
 2  | 'ccc'
 0  | 'aaa'
 1  | 'bbb'
 2  | 'ccc'
Is there a way to delete the duplicated data without build another table with
constraints and copy those data to the new table?
Something like "delete from table1 where ...???"

Thanks,
Lucas