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 по дате отправления