Windowing functions - future plans

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Windowing functions - future plans
Date: 2009-11-01 11:04:32
Message-ID: hcjpvu$1lp$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2009-11-01 11:10:03 Re: Postgres alpha testing docs and general test packs
Previous Message Peter Eisentraut 2009-11-01 10:25:33 Re: Emal reg expression