From: Andy Lewis <alewis@mpsi.net>
To: phd2@earthling.net
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Duplicate rows
Date: Sat, 16 May 1998 08:18:05 -0500 (CDT)
Message-ID: <Pine.LNX.3.95.980516081545.14769B-100000@shell.mpsi.net> (raw)
In-Reply-To: <Pine.LNX.3.96.SK.980516132904.20715B-100000@torus.comus.ru>
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.
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alewis@mpsi.net, phd2@earthling.net
Subject: Re: [SQL] Duplicate rows
In-Reply-To: <Pine.LNX.3.95.980516081545.14769B-100000@shell.mpsi.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox