Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id EB3C19FB25C
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  2 Feb 2007 09:49:11 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 96183-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  2 Feb 2007 09:49:01 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169])
	by postgresql.org (Postfix) with ESMTP id DB38A9FA6B5
	for <pgsql-sql@postgresql.org>; Fri,  2 Feb 2007 09:49:00 -0400 (AST)
Received: by ug-out-1314.google.com with SMTP id k3so679900ugf
	for <pgsql-sql@postgresql.org>; Fri, 02 Feb 2007 05:48:59 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=CC65wKiwf5OdsZPivcDJNO/PPESNy8MLIAtMpuZ28LQL5qKD5CKFRfpDSCZ2H8BVhdGF1aZ1XVMnlRmqdafNmr+/BqH20flgFxBxmz8jpTp5HUhQCCGif6w060LZQTt4K0d8VwdJLGj20920ZGKnoG/VmfVDTIdxpBhufBOeKV0=
Received: by 10.67.93.6 with SMTP id v6mr4447899ugl.1170424139255;
	Fri, 02 Feb 2007 05:48:59 -0800 (PST)
Received: by 10.66.217.13 with HTTP; Fri, 2 Feb 2007 05:48:59 -0800 (PST)
Message-ID: <55c095e90702020548h4c5ae5b2h405a2a33fb5b950@mail.gmail.com>
Date: Fri, 2 Feb 2007 11:48:59 -0200
From: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Duplicate records
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_20638_29648301.1170424139212"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/10
X-Sequence-Number: 27344

------=_Part_20638_29648301.1170424139212
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi list,

I am making some data minning and would like to know if someone tell me how
to retrieve the duplicate records based in one or two fields of my table.

Any help would be welcomed.

--=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/

------=_Part_20638_29648301.1170424139212
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi list,<br><br>I am making some data minning and would like to know if som=
eone tell me how to retrieve the duplicate records based in one or two fiel=
ds of my table.<br><br>Any help would be welcomed.<br clear=3D"all"><br>--=
=20
<br> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D<br>&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Atenciosamente (Sincerely)<br=
>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ezequ=
ias Rodrigues da Rocha<br> =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-
<br>A pior das democracias ainda =E9 melhor do que a melhor das ditaduras<b=
r>The worst of democracies is still better than the better of dictatorships=
<br><a href=3D"http://ezequiasrocha.blogspot.com/">http://ezequiasrocha.blo=
gspot.com/
</a>

------=_Part_20638_29648301.1170424139212--