Teodor Sigaev <teo...@sigaev.ru> writes:
> 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?
You would need to put the cast around the whole "foo() over ()"
construct. That's not a divisible unit.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
