Postgres Pro
Downloads
Home   >   mailing lists

Windowing functions - future plans - Mailing list pgsql-general

From Thomas Kellerer
Subject Windowing functions - future plans
Date
Msg-id hcjpvu$1lp$1@ger.gmane.org
Whole thread Raw
Responses Re: Windowing functions - future plans  (David Fetter <david@fetter.org>)
List pgsql-general
Tree view 
Hi,

I was wondering if there are plans to extend the window framing clause to allow the number of rows in the frame to be
specified. 

Something like:

ROWS BETWEEN 5 PRECEDING AND 5 FOLLOWING

I did find a comment on the TODO list regarding the framing clause ("Implement full support for window framing
clauses")but the explanation did not mention allowing a number instead of UNBOUND for the frame definition.  

Oracle and DB2 do support this syntax ;)

Regards
Thomas

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Emal reg expression
Next
From: Thom Brown
Date:
Subject: Re: Postgres alpha testing docs and general test packs