Quick Links

Deleting one of 2 identical records

From:	"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To:	"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	Deleting one of 2 identical records
Date:	2011-09-06 17:39:14
Message-ID:	482E80323A35A54498B8B70FF2B8798004CFD61D01@azsmsx504.amr.corp.intel.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

Hi:

If I have a table that has 2 records which are identical with regard to all their column values, is there a way to delete one of them, leaving one remaining? Is there some unique record_id key of some sort I can use for somethign like this?

Thanks in Advance!

Responses

Re: Deleting one of 2 identical records at 2011-09-06 17:44:43 from Thom Brown
Re: Deleting one of 2 identical records at 2011-09-06 17:52:08 from Andy Colson
Re: Deleting one of 2 identical records at 2011-09-06 17:57:35 from Andreas Kretschmer

Browse pgsql-general by date

	From	Date	Subject
Next Message	Thom Brown	2011-09-06 17:44:43	Re: Deleting one of 2 identical records
Previous Message	Susan Cassidy	2011-09-06 17:37:13	Re: Backend process that won't die