| From: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: find the greatest, pick it up and group by |
| Date: | 2011-05-17 00:26:50 |
| Message-ID: | 20110517022650.68b1a102@dawn.webthatworks.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 16 May 2011 20:05:45 -0400
"David Johnston" <polobo(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bernardo Telles | 2011-05-17 02:17:45 | Re: How do we combine and return results from multiple queries in a loop? |
| Previous Message | David Johnston | 2011-05-17 00:05:45 | Re: find the greatest, pick it up and group by |