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: teo...@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
