Re: using window-functions to get freshest value - how?

[Thom Brown <thombrown@xxxxxxxxx>]

2009/11/20 silly8888 <silly8888@xxxxxxxxx>

> 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