Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 2E8609FB1BA
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  2 Feb 2007 09:55:20 -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 96908-02-2 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  2 Feb 2007 09:55:13 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from nz-out-0506.google.com (nz-out-0506.google.com
 [64.233.162.228])
	by postgresql.org (Postfix) with ESMTP id 26FD79FB26A
	for <pgsql-sql@postgresql.org>; Fri,  2 Feb 2007 09:55:12 -0400 (AST)
Received: by nz-out-0506.google.com with SMTP id i11so832223nzh
	for <pgsql-sql@postgresql.org>; Fri, 02 Feb 2007 05:55:11 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=HMOJSqy3h8Hgvvc8fM10LG4HG3mxhsBFGWzS/qREUEQEW6zt5/VnULXXkEnod2BWrNlwNprmo/P67NG3WMTsK6UF2Q8vDiAw5UHhPwof2daVAoknND7NGVqMxA4ILaxyrCkU3bK2YJnbYvQLuKGX94g5nwh9jxGX7RengrR6/As=
Received: by 10.65.251.1 with SMTP id d1mr6076479qbs.1170424511296;
	Fri, 02 Feb 2007 05:55:11 -0800 (PST)
Received: by 10.65.206.17 with HTTP; Fri, 2 Feb 2007 05:55:11 -0800 (PST)
Message-ID: <bf54be870702020555s3f2a6eaam4eddd3149b122d5c@mail.gmail.com>
Date: Fri, 2 Feb 2007 18:55:11 +0500
From: "Shoaib Mir" <shoaibmir@gmail.com>
To: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
Subject: Re: Duplicate records
Cc: pgsql-sql@postgresql.org
In-Reply-To: <55c095e90702020548h4c5ae5b2h405a2a33fb5b950@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_15697_27417285.1170424511168"
References: <55c095e90702020548h4c5ae5b2h405a2a33fb5b950@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200702/12
X-Sequence-Number: 27346

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

That has been asked in the past a number of time too, you can look at the
following for details -->
http://archives.postgresql.org/pgsql-novice/2006-06/msg00093.php

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/2/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:
>
> 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.
>
> --
> =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_15697_27417285.1170424511168
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

That has been asked in the past a number of time too, you can look at the f=
ollowing for details --&gt; <a href=3D"http://archives.postgresql.org/pgsql=
-novice/2006-06/msg00093.php">http://archives.postgresql.org/pgsql-novice/2=
006-06/msg00093.php
</a><br><br>--<br>Shoaib Mir<br>EnterpriseDB (<a href=3D"http://www.enterpr=
isedb.com">www.enterprisedb.com</a>)<br><br><div><span class=3D"gmail_quote=
">On 2/2/07, <b class=3D"gmail_sendername">Ezequias Rodrigues da Rocha</b> =
&lt;
<a href=3D"mailto:ezequias.rocha@gmail.com">ezequias.rocha@gmail.com</a>&gt=
; wrote:</span><blockquote class=3D"gmail_quote" style=3D"border-left: 1px =
solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi=
 list,
<br><br>I am making some data minning and would like to know if someone tel=
l me how to retrieve the duplicate records based in one or two fields 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=
><span class=3D"sg">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;Ezequias 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/" target=3D"_blank" onclic=
k=3D"return top.js.OpenExtLink(window,event,this)">
http://ezequiasrocha.blogspot.com/
</a>
</span></blockquote></div><br>

------=_Part_15697_27417285.1170424511168--