Skip site navigation (1) Skip section navigation (2)

Deleting duplicate records

From: "Paul S(dot) Ganney" <paul(dot)ganney(at)dial(dot)pipex(dot)com>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Deleting duplicate records
Date: 1999-12-07 16:46:30
Message-ID: 384D39E6.6459@dial.pipex.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
This probably sounds horribly trivial, but still...

I've managed to get some duplicate records in a table and am having 
problems getting rid of them (as there's nothing unique to SELECT on). 
Any ideas?

And whilst I'm at it - any ideas on a scheme for preventing duplicates?

Paul.
-- 
-------------------------------------------
Expressed opinions are usually my own.
Especially if they're any good (of course).
-------------------------------------------


pgsql-interfaces by date

Next:From: Ross J. ReedstromDate: 1999-12-07 17:12:34
Subject: Re: [INTERFACES] locking on database updates
Previous:From: Gary StainburnDate: 1999-12-07 16:34:37
Subject: RE: [INTERFACES] locking on database updates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group