Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 94FFA632FEB
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 10 Aug 2010 17:05:10 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 84470-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 10 Aug 2010 20:05:02 +0000 (UTC)
X-Greylist: delayed 00:05:13.387806 by SQLgrey-1.7.6
Received: from forward11.mail.yandex.net (forward11.mail.yandex.net
	[95.108.130.93])
	by mail.postgresql.org (Postfix) with ESMTP id 82E36632BBB
	for <pgsql-sql@postgresql.org>; Tue, 10 Aug 2010 17:05:02 -0300 (ADT)
Received: from web142.yandex.ru (web142.yandex.ru [95.108.130.10])
	by forward11.mail.yandex.net (Yandex) with ESMTP id BFE173ED035A;
	Tue, 10 Aug 2010 23:59:46 +0400 (MSD)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail;
	t=1281470386; bh=sdmCHL+5sAeycZ5nf555eyBWnCtG4+f7/radZ08eETE=;
	h=From:To:Cc:In-Reply-To:References:Subject:MIME-Version:Message-Id:
	Date:Content-Transfer-Encoding:Content-Type;
	b=lC60cvltwxjoD5IPeeDsh7al3TO07YhFnq7R3aZLF8BSkuNllOi72wFb0evXrvsJf
	6M1EPY4vYs7CG3mQRuaw2kAtvS2WfL2XNXUt8jLMgW36zpa3CBXC+BqTjXdRX/lc9q
	yLMp784jAOpqdKgMKXTdxuSdxuoBGkZXvpcfDrno=
Received: from localhost (localhost.localdomain [127.0.0.1])
	by web142.yandex.ru (Yandex) with ESMTP id BC2CF3018064;
	Tue, 10 Aug 2010 23:59:46 +0400 (MSD)
X-Yandex-Spam: 1
X-Yandex-Front: web142.yandex.ru 
X-Yandex-TimeMark: 1281470386 
Received: from user-28.81.118.217.in-addr.arpa
	(user-28.81.118.217.in-addr.arpa [217.118.81.28]) by
	mail.yandex.ru with HTTP; Tue, 10 Aug 2010 23:59:46 +0400
From: msi77 <msi77@yandex.ru>
To: Edward W. Rouse <erouse@comsquared.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <00b701cb38c0$d64fc760$82ef5620$@com>
References: <00b701cb38c0$d64fc760$82ef5620$@com>
Subject: Re: Duplicate rows
MIME-Version: 1.0
Message-Id: <264231281470386@web142.yandex.ru>
Date: Tue, 10 Aug 2010 23:59:46 +0400
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.917 tagged_above=-5 required=5 tests=BAYES_50=0.8,
	RCVD_IN_BL_SPAMCOP_NET=1.347, RCVD_IN_SORBS_WEB=0.77
X-Spam-Level: **
X-Archive-Number: 201008/48
X-Sequence-Number: 34488

A few ways to do this: 
http://www.sql-ex.ru/help/select17.php

> Is there any way to remove a duplicate row from a table? Not my db but I have to work with it. On version 7.4 right now.
> Edward W. Rouse
> Comsquared System, Inc.
> 770-734-5301
>