2009/11/20 silly8888 <silly8...@gmail.com> > > and how would I use DISTINCT ON for this query? Please bear in mind, > > that there is more then one id_bf (just stopped the sample data with > > one of them) > > I posted the answer more than hour ago: > > SELECT DISTINCT ON (id_rf) * FROM rfmitzeit ORDER BY id_rf, > letztespeicherung DESC; > > Ah yes, I mixed up the id_rf and id_bf. Yeah, this is what I would use (although I personally avoid using *).
Thom
