Re: How to find not unique rows in a table?

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "A B *EXTERN*" <gentosaker(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to find not unique rows in a table?
Date: 2008-10-08 14:28:02
Message-ID: D960CB61B694CF459DCFB4B0128514C20296662E@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A B wrote:
> Assuming you have a table where some rows have the same values in all
> columnes, how do you find these rows?

There is no reliable, time-independent way.
That's one reason why you have primary keys on tables.

There is the system column "ctid", but that may change any second.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Kohll 2008-10-08 14:47:13 Re: Stats collector eats my CPU
Previous Message Andrew Sullivan 2008-10-08 14:10:18 Re: 8.4 RPMs