Re: deleting an identical record

Поиск
Список
Период
Сортировка
От Hugo Coolens
Тема Re: deleting an identical record
Дата
Msg-id 3C749149.FF5E814D@skynet.be
обсуждение исходный текст
Ответ на Re: deleting an identical record  (missive@frontiernet.net (Lee Harr))
Список 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 по дате отправления:

Предыдущее
От: Jean-Michel POURE
Дата:
Сообщение: Re: PostgreSQL GUI?
Следующее
От: Jason Earl
Дата:
Сообщение: Re: ANY GOOD USER'S GUIDE ONLINE?? (with simple examples)