O kyrios Christoph Haller egrapse stis Jun 16, 2004 : > Referring to the DISTINCT ON example > > SELECT DISTINCT ON (location) location, time, report > FROM weatherReports > ORDER BY location, time DESC;
maybe smth like delete from weatherReports where (location,time,report) not in (SELECT DISTINCT ON (location) location, time, report FROM weatherReports ORDER BY location, time DESC) Note: Order by is very important, since it affects which rows are deleted. > > How would I delete those entries skipped by the DISTINCT ON expression? > > TIA > > Regards, Christoph > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- -Achilleus ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
