Re: find the greatest, pick it up and group by - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: find the greatest, pick it up and group by
Date
Msg-id 20110517022650.68b1a102@dawn.webthatworks.it
Whole thread Raw
In response to Re: find the greatest, pick it up and group by  ("David Johnston" <polobo@yahoo.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "David Johnston"
Date:
Subject: Re: find the greatest, pick it up and group by
Next
From: Bernardo Telles
Date:
Subject: Re: How do we combine and return results from multiple queries in a loop?