Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #4829: nth_value does not allow window frame - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4829: nth_value does not allow window frame
Date
Msg-id 362.1243545148@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4829: nth_value does not allow window frame  ("lily li" <lil@sybase.com>)
List pgsql-bugs
Tree view 
"lily li" <lil@sybase.com> writes:
> It looks like postgreSQl 8.4 does not allow window frame clause inside OVER
> clause.

What it allows is spelled out in the fine manual:
http://www.postgresql.org/docs/8.4/static/sql-expressions.html#SYNTAX-WINDOW-FUNCTIONS

Future versions of PG might support more, but this is as far as 8.4
is going.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "lily li"
Date:
Subject: BUG #4829: nth_value does not allow window frame
Next
From: Euler Taveira de Oliveira
Date:
Subject: Re: BUG #4827: install