| From: | Christoph Haller <ch(at)rodos(dot)fzk(dot)de> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | How to delete the not DISTINCT ON entries |
| Date: | 2004-06-16 11:52:57 |
| Message-ID: | 40D03499.84F9354F@rodos.fzk.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-general 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2004-06-16 12:18:26 | Re: How to delete the not DISTINCT ON entries |
| Previous Message | Kris Jurka | 2004-06-16 05:14:29 | Re: BUG #1121: JDBC AbstractJdbc2ResultSet.deleteRow() |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2004-06-16 12:18:26 | Re: How to delete the not DISTINCT ON entries |
| Previous Message | Bill Moran | 2004-06-16 11:08:54 | Re: 7.4 performance issue |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleus Mantzios | 2004-06-16 12:18:26 | Re: How to delete the not DISTINCT ON entries |
| Previous Message | Stijn Vanroye | 2004-06-16 07:27:24 | Re: Your question in postgresql.org forum (Diff. between two times as a numeric value in a stored proc) |