Re: [GENERAL] PostgreSQL 9.0 - support for RANGE value PRECEDING window functions

2010-05-10 Thread Tom Lane
Daniel Scott writes: > On Mon, May 10, 2010 at 13:35, Alvaro Herrera wrote: >> It was ripped out of the patch before commit because the implementation was >> not >> acceptable. > That's strange - the CommitFest says that it was committed and I can't > find any mention of it being removed. Is th

Re: [GENERAL] PostgreSQL 9.0 - support for RANGE value PRECEDING window functions

2010-05-10 Thread Daniel Scott
Hi, On Mon, May 10, 2010 at 13:35, Alvaro Herrera wrote: > It was ripped out of the patch before commit because the implementation was > not > acceptable. That's strange - the CommitFest says that it was committed and I can't find any mention of it being removed. Is there somewhere I can see a

Re: [GENERAL] PostgreSQL 9.0 - support for RANGE value PRECEDING window functions

2010-05-10 Thread Alvaro Herrera
Excerpts from Daniel Scott's message of lun may 10 13:20:06 -0400 2010: > Says "The value PRECEDING and value FOLLOWING cases are currently only > allowed in ROWS mode." > > However, I have found this post: > > http://archives.postgresql.org/message-id/e08cc0400912310149me7150cek3c9aa92e4d396...

[GENERAL] PostgreSQL 9.0 - support for RANGE value PRECEDING window functions

2010-05-10 Thread Daniel Scott
Hi, I have a question about a feature in PostgreSQL 9.0. I am looking for support for windowing functions when using: RANGE BETWEEN PRECEDING/FOLLOWING AND PRECEDING/FOLLOWING The latest documentation: http://www.postgresql.org/docs/9.0/static/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS Say