Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicate Row Removal - Mailing list pgsql-general

From Tom Lane
Subject Re: Duplicate Row Removal
Date
Msg-id 9039.1131171861@sss.pgh.pa.us
Whole thread Raw
In response to Duplicate Row Removal  ("Peter Atkins" <patkins@directpartners.com>)
List pgsql-general
Tree view 
"Peter Atkins" <patkins@directpartners.com> writes:
> I was hoping to have a system oid for each row but it looks like that's
> not the case. Anyone have any thoughts on how to remove dups?

ctid always works ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Peter Atkins"
Date:
Subject: Duplicate Row Removal
Next
From: "Dean Gibson (DB Administrator)"
Date:
Subject: Re: Duplicate Row Removal