Re: PostgreSQL 9.0 - support for RANGE value PRECEDING window functions - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: PostgreSQL 9.0 - support for RANGE value PRECEDING window functions
Date
Msg-id 1273512863-sup-896@alvh.no-ip.org
Whole thread Raw
In response to PostgreSQL 9.0 - support for RANGE value PRECEDING window functions  (Daniel Scott <djscott@mit.edu>)
Responses Re: PostgreSQL 9.0 - support for RANGE value PRECEDING window functions  (Daniel Scott <djscott@mit.edu>)
List pgsql-general
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/e08cc0400912310149me7150cek3c9aa92e4d396ac3@mail.gmail.com
>
> Which appears to provide a patch supporting: "- allow all of RANGE
> BETWEEN <value> PRECEDING/FOLLOWING AND <value>
> PRECEDING/FOLLOWING". However, I cannot find any further information
> related to this feature.

It was ripped out of the patch before commit because the implementation was not
acceptable.

> Can anyone confirm whether or not this feature will be available in
> PostgreSQL 9.0?

No.
--

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: How to do pg_dump + pg_restore within Perl script?
Next
From: Peter Hunsberger
Date:
Subject: Re: Sorting with materialized paths