Re: deleting an identical record - Mailing list pgsql-general

From Hugo Coolens
Subject Re: deleting an identical record
Date
Msg-id 3C749149.FF5E814D@skynet.be
Whole thread Raw
In response to Re: deleting an identical record  (missive@frontiernet.net (Lee Harr))
List 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?


pgsql-general by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: PostgreSQL GUI?
Next
From: Jason Earl
Date:
Subject: Re: ANY GOOD USER'S GUIDE ONLINE?? (with simple examples)