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: (view raw, whole thread or download thread mbox)
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?

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-2017 The PostgreSQL Global Development Group