Re: deleting an identical record

Oliver Elphick wrote:
>
> On Thu, 2002-02-21 at 03:44, 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;
>
> Aren't the oids different?
>
> DELETE FROM t WHERE oid <> xxx
>
 OUCH !!! There will be only one row left in the table.  Be carefull.