Re: [SQL] Duplicate rows

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.