Re: [SQL] Duplicate rows

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(at)earthling(dot)net
> Programmers don't die, they just GOSUB without RETURN.
>
>