Windowing functions vs aggregates

Поиск
Список
Период
Сортировка
Искать
От
Teodor Sigaev
Тема
Windowing functions vs aggregates
Дата
Msg-id
49E48BC5.6010803@sigaev.ru
Список
Дерево обсуждения
Windowing functions vs aggregates Teodor Sigaev <teodor@sigaev.ru>
Re: Windowing functions vs aggregates Greg Stark <stark@enterprisedb.com>
Re: Windowing functions vs aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Windowing functions vs aggregates Tom Lane <tgl@sss.pgh.pa.us>
Cast of aggregate's type works:
# select avg(s)::int4 from foo;

but that doesn't work for with new windowing functions interface:
# select avg(s)::int4 OVER () from foo;
ERROR:  syntax error at or near "OVER"
LINE 1: select avg(s)::int4 OVER () from foo;

Is that intentional?

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru                                                   WWW: http://www.sigaev.ru/

В списке pgsql-hackers по дате отправления
От: Zdenek Kotala
Дата:
Сообщение: libpq is not thread safe
От: Greg Stark
Дата:
FAQ