> 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 *).
