Windowing functions - future plans

Поиск
Список
Период
Сортировка
Искать
От
Thomas Kellerer
Тема
Windowing functions - future plans
Дата
Msg-id
hcjpvu$1lp$1@ger.gmane.org
Список
Дерево обсуждения
Windowing functions - future plans Thomas Kellerer <spam_eater@gmx.net>
Re: Windowing functions - future plans David Fetter <david@fetter.org>
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 по дате отправления
От: Peter Eisentraut
Дата:
Сообщение: Re: Emal reg expression
От: Thom Brown
Дата:
FAQ