Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: using window-functions to get freshest value - how?
Date
Msg-id 20091120111535.GB30145@depesz.com
Whole thread Raw
In response to using window-functions to get freshest value - how?  ("Massa, Harald Armin" <chef@ghum.de>)
Responses Re: using window-functions to get freshest value - how?  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: using window-functions to get freshest value - how?  ("Massa, Harald Armin" <chef@ghum.de>)
List pgsql-general
Tree view 
On Fri, Nov 20, 2009 at 11:07:37AM +0100, Massa, Harald Armin wrote:
> 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".

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-general by date:

Previous
From: silly8888
Date:
Subject: Re: using window-functions to get freshest value - how?
Next
From: Thomas Kellerer
Date:
Subject: Re: using window-functions to get freshest value - how?