Deleting one of 2 identical records

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема Deleting one of 2 identical records
Дата
Msg-id 482E80323A35A54498B8B70FF2B8798004CFD61D01@azsmsx504.amr.corp.intel.com
обсуждение исходный текст
Ответы Re: Deleting one of 2 identical records  (Thom Brown <thom@linux.com>)
Re: Deleting one of 2 identical records  (Andy Colson <andy@squeakycode.net>)
Re: Deleting one of 2 identical records  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список pgsql-general

Hi:

 

If I have a table that has 2 records which are identical with regard to all their column values, is there a way to delete one of them, leaving one remaining?  Is there some unique record_id key of some sort I can use for somethign like this?

 

Thanks in Advance!

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

Предыдущее
От: Susan Cassidy
Дата:
Сообщение: Re: Backend process that won't die
Следующее
От: Thom Brown
Дата:
Сообщение: Re: Deleting one of 2 identical records