Date: Tue, 24 May 2005 23:26:04 +0200
To: lucas@presserv.org, pgsql-sql@postgresql.org
Subject: Re: Duplicated records
References: <20050524175931.4dp41vy7v10c4wc4@www.presserv.org>
From: PFC <lists@boutiquenumerique.com>
Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?=
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Message-ID: <op.srattqosth1vuj@localhost>
In-Reply-To: <20050524175931.4dp41vy7v10c4wc4@www.presserv.org>
User-Agent: Opera M2(BETA2)/8.0 (Linux, build 987)


> 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.

	If you have no primary key how can you reference a record in order to  
delete it ?
	I'd say use a temporary table...
	If you have complete row dupes (ie. the entire row is duplicated) use
	SELECT * FROM table GROUP BY *
	(or select distinct)

	If only the primary key is duplicated but other fields change, then you  
have to decide which one you wanna keep !