Skip site navigation (1) Skip section navigation (2)

BUG #4829: nth_value does not allow window frame

From: "lily li" <lil(at)sybase(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4829: nth_value does not allow window frame
Date: 2009-05-28 20:13:02
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4829
Logged by:          lily li
Email address:      lil(at)sybase(dot)com
PostgreSQL version: 8.4.0-lb2-windo
Operating system:   window 2000
Description:        nth_value does not allow window frame

I type in query
select c1, c2, nth_value(c2, 2)over (partition by c1 order by c2 rows
between 1 preceding and 1 following) from tab1;

I got syntext error ' error near '1';

without window frame clause query returned correct results;

According to 2008:SQL nth_value and first_value support window frame

It looks like postgreSQl 8.4 does not allow window frame clause inside OVER

Is this the current limitatio? Or a bug.

Thank you.


pgsql-bugs by date

Next:From: Tom LaneDate: 2009-05-28 21:12:28
Subject: Re: BUG #4829: nth_value does not allow window frame
Previous:From: Tom LaneDate: 2009-05-28 19:41:47
Subject: Re: BUG #4828: Fault a foreign key

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group