Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL:2003 Window Functions for postgresql 8.3? - Mailing list pgsql-general

From AgentM
Subject Re: SQL:2003 Window Functions for postgresql 8.3?
Date
Msg-id 9E4CEC70-C260-49FB-8971-904DDCA4EAA2@themactionfaction.com
Whole thread Raw
In response to Re: SQL:2003 Window Functions for postgresql 8.3?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: SQL:2003 Window Functions for postgresql 8.3?  ("Dann Corbit" <DCorbit@connx.com>)
Re: SQL:2003 Window Functions for postgresql 8.3?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: SQL:2003 Window Functions for postgresql 8.3?  (Ben <bench@silentmedia.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: getting around 'out of memory' errors
Next
From: "Dann Corbit"
Date:
Subject: Re: SQL:2003 Window Functions for postgresql 8.3?