Received: from shell.mpsi.net (shell.mpsi.net [207.252.220.24]) by hub.org
	(8.8.8/8.7.5) with ESMTP id JAA01373 for <pgsql-sql@postgreSQL.org>;
	Sat, 16 May 1998 09:18:07 -0400 (EDT)
Received: from localhost (alewis@localhost)
	by shell.mpsi.net (8.8.6/8.8.6.Beta3) with SMTP id NAA14806;
	Sat, 16 May 1998 13:18:05 GMT
Date: Sat, 16 May 1998 08:18:05 -0500 (CDT)
From: Andy Lewis <alewis@mpsi.net>
To: phd2@earthling.net
cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Duplicate rows
In-Reply-To: <Pine.LNX.3.96.SK.980516132904.20715B-100000@torus.comus.ru>
Message-ID: <Pine.LNX.3.95.980516081545.14769B-100000@shell.mpsi.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

Right, I know that there are dups in the column. But, I don't know where they
are nor do I know their value(s). I want to be able to find, say, two interger
values that are in the same column but, different rows.

Thanks

Andy

On Sat, 16 May 1998, Oleg Broytmann wrote:

>Hello.
>
>On Fri, 15 May 1998, Andy Lewis wrote:
>> I have a postgres db with at least 1000 rows in it. I'd like to know if its
>> possible to detect duplicate values of a column if I don't know which values
>> that are dups?
>
>   Try to create UNIQUE index on a problematic column. If creating the
>unique index failes - there are duplicates (providing that creating the
>index wouldn't fail by other reasons - disk full, memory shortage, etc.)
>
>Oleg.
>---- 
>  Oleg Broytmann     http://members.tripod.com/~phd2/     phd2@earthling.net
>           Programmers don't die, they just GOSUB without RETURN.
>
>