Re: find the greatest, pick it up and group by

On Mon, 16 May 2011 20:05:45 -0400
"David Johnston" <polobo@yahoo.com> wrote:

> When asking for help on non-trivial SELECT queries it really helps
> to tell us the version of PG you are using so that responders know
> what functionality you can and cannot use.  In this case
> specifically, whether WINDOW (and maybe WITH) clauses available?

Unfortunately I'm on 8.3 so no WINDOW.

I didn't even think of using them and I can't think of any way to
use WINDOW/WITH but if there is a more readable solution that use
them I'd like to see it even if I won't be able to use it.
Of course I'm more interested to know if there is any cleaner
solution for 8.3.

thanks

--
Ivan Sergio Borgonovo
http://www.webthatworks.it