Postgres Pro
Downloads
Home   >   mailing lists

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 e3e180dc0911200231v3ef9eea0p61dd9640c66fae51@mail.gmail.com
Whole thread Raw
In response to Re: using window-functions to get freshest value - how?  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: using window-functions to get freshest value - how?  (silly8888 <silly8888@gmail.com>)
Re: using window-functions to get freshest value - how?  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view
    id_bf,  wert, letztespeicherung:
  98,  'blue', 2009-11-09
  98,  'red', 2009-11-10
    now I have a select to get the "youngest value" for every id_bf:

Not tested:

SELECT id_bf,      wert,
     max(letztespeicherung) over (partition by id_bf)
FROM rfmitzeit

no, that does not work:
"id_bf";"wert";"max"
98;"blue";"2009-11-10 00:00:00"
98;"red";"2009-11-10 00:00:00"

result is: I get the date of the youngest value.

My expected result is:

98;"red"

(that is, the entry of "wert" that is youngest)

thanks for trying,

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: Thomas Kellerer
Date:
Subject: Re: using window-functions to get freshest value - how?
Next
From: silly8888
Date:
Subject: Re: using window-functions to get freshest value - how?