contracting tables

Поиск
Список
Период
Сортировка
Hi--

I have a table with many records, some of which are duplicates (there is no
unique constraints). How can I contract this table to remove any of these
duplicate records? Like when using GROUP BY in a select statement, except
that I want to just remove the extra entries from this table directly... Any
ideas?


Thanks,

Peter Brown



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PL/pgSQL loops?
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Fixing faulty dates - select on day part of a date field