How to delete the not DISTINCT ON entries

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема How to delete the not DISTINCT ON entries
Дата
Msg-id 40D03499.84F9354F@rodos.fzk.de
обсуждение исходный текст
Ответы Re: How to delete the not DISTINCT ON entries
Список pgsql-sql
Дерево обсуждения 
Referring to the DISTINCT ON example

SELECT DISTINCT ON (location) location, time, report
FROM weatherReports
ORDER BY location, time DESC;

How would I delete those entries skipped by the DISTINCT ON expression?

TIA

Regards, Christoph

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

Предыдущее
От: "Stijn Vanroye"
Дата:
Сообщение: Re: Your question in postgresql.org forum (Diff. between two times as a numeric value in a stored proc)
Следующее
От: Achilleus Mantzios
Дата:
Сообщение: Re: How to delete the not DISTINCT ON entries