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

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Daniel Scott <djscott(at)mit(dot)edu>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL 9.0 - support for RANGE value PRECEDING window functions
Date: 2010-05-10 17:35:25
Message-ID: 1273512863-sup-896@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.
--

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Hunsberger 2010-05-10 17:55:31 Re: Sorting with materialized paths
Previous Message Greg Sabino Mullane 2010-05-10 17:33:49 Re: How to do pg_dump + pg_restore within Perl script?