| From: | AgentM <agentm(at)themactionfaction(dot)com> |
|---|---|
| To: | PostgreSQL General ML <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SQL:2003 Window Functions for postgresql 8.3? |
| Date: | 2006-08-24 18:26:53 |
| Message-ID: | 9E4CEC70-C260-49FB-8971-904DDCA4EAA2@themactionfaction.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Aug 24, 2006, at 14:11 , Alvaro Herrera wrote:
> Karen Hill wrote:
>
>> It would be really great if PostgreSQL supported SQL:2003 Window
>> functions. I know that oracle and sql server have them already,
>> so it
>> would make postgres competitive in that area. I know there is a
>> feature freeze for 8.2, is it doable for 8.3?
>
> The sooner you start writing a patch, the sooner you will be done ;-)
>
> I agree it would be nice to have them, but currently I don't think
> there's anyone working on'em.
Could someone elaborate on the window functions? This page http://
en.wikipedia.org/wiki/SELECT has some examples but they make it seem
like the functions are an overly-verbose LIMIT statement. So what's
the benefit?
-M
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2006-08-24 18:36:58 | Re: SQL:2003 Window Functions for postgresql 8.3? |
| Previous Message | Tom Lane | 2006-08-24 18:12:48 | Re: getting around 'out of memory' errors |