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.