BUG #4829: nth_value does not allow window frame

Поиск
Список
Период
Сортировка
От lily li
Тема BUG #4829: nth_value does not allow window frame
Дата
Msg-id 200905282013.n4SKD2pP055071@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #4829: nth_value does not allow window frame
Список pgsql-bugs
The following bug has been logged online:

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

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
clause.

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

Is this the current limitatio? Or a bug.

Thank you.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4828: Fault a foreign key
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #4829: nth_value does not allow window frame