Postgres Pro
Downloads
Home   >   mailing lists

How to delete the not DISTINCT ON entries - Mailing list pgsql-sql

From Christoph Haller
Subject How to delete the not DISTINCT ON entries
Date
Msg-id 40D03499.84F9354F@rodos.fzk.de
Whole thread Raw
Responses Re: How to delete the not DISTINCT ON entries
List pgsql-sql
Tree view 
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 by date:

Previous
From: "Stijn Vanroye"
Date:
Subject: Re: Your question in postgresql.org forum (Diff. between two times as a numeric value in a stored proc)
Next
From: Achilleus Mantzios
Date:
Subject: Re: How to delete the not DISTINCT ON entries