Re: deleting an identical record

From: Hugo Coolens <hugo(dot)coolens(at)skynet(dot)be>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: deleting an identical record
Date: 2002-02-21 06:18:49
Message-ID: 3C749149.FF5E814D@skynet.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lee Harr wrote:

> > 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;

thanks, this works indeed, what's the meaning of the comma behind oid?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth McDowell 2002-02-21 06:26:06 Createdb problems
Previous Message Tom Lane 2002-02-21 06:15:09 Re: entering empty value