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

From missive@frontiernet.net (Lee Harr)
Subject Re: deleting an identical record
Date
Msg-id slrna78r5n.75.missive@whave.frontiernet.net
Whole thread Raw
Responses Re: deleting an identical record  (Oliver Elphick <olly@lfix.co.uk>)
List 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;




pgsql-general by date:

Previous
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: batch file
Next
From: missive@frontiernet.net (Lee Harr)
Date:
Subject: Re: Date problem