> > Is it possible? How would the SQL utilizing WINDOW-functions look like? > > there is no point in using window functions in here - simply use > "DISTINCT ON".
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) Best wishes, Harald -- GHUM Harald Massa persuadere et programmare Harald Armin Massa Spielberger Straße 49 70435 Stuttgart 0173/9409607 no fx, no carrier pigeon - %s is too gigantic of an industry to bend to the whims of reality -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
