deleting an identical record

From: Hugo Coolens <hugo(dot)coolens(at)skynet(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: deleting an identical record
Date: 2002-02-20 23:58:10
Message-ID: 3C743812.EC8ADD13@skynet.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In a table I entered by accident two times the same record, if I now
list the table I see two lines with exactly the same contents. How can
I delete one of those two records? I can't find a select criterium which
differs for both.

regards,
Hugo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message corey 2002-02-21 00:56:33 libpq++ problem
Previous Message Hugo Coolens 2002-02-20 23:54:56 entering empty value