Re: using window-functions to get freshest value - how? - Mailing list pgsql-general

From Massa, Harald Armin
Subject Re: using window-functions to get freshest value - how?
Date
Msg-id e3e180dc0911200408q5be040dbk2aa48ff007da8c01@mail.gmail.com
Whole thread Raw
In response to Re: using window-functions to get freshest value - how?  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: using window-functions to get freshest value - how?
Re: using window-functions to get freshest value - how?
Re: using window-functions to get freshest value - how?
List pgsql-general
> > 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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: using window-functions to get freshest value - how?
Next
From: Thom Brown
Date:
Subject: Re: using window-functions to get freshest value - how?