Re: deleting an identical record

From: missive(at)frontiernet(dot)net (Lee Harr)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: deleting an identical record
Date: 2002-02-21 03:44:51
Message-ID: slrna78r5n.75.missive@whave.frontiernet.net
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.
>

create table t (a int, b text);

insert into t values (1, 'a');
insert into t values (1, 'a');
insert into t values (1, 'a');
insert into t values (1, 'a');

select oid, * from t;

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2002-02-21 03:46:08 Re: batch file
Previous Message Lee Harr 2002-02-21 03:43:41 Re: entering empty value