Re: TODO items for window functions

"Jaime Casanova" <jcasanov@systemguards.com.ec> writes:
> i don't understand this window function stuff well yet, but AFAIU it
> is like an aggregate function that shows grouped values without
> grouping rows (ok, maybe a very laizy or novice definition) but if
> that is correct or near correct maybe we need to follow the same
> pattern:

> create function -- without any decoration
> create aggregate maybe with a decoration of being window o create
> window aggregate or something similar...

No, we can't really manage this as a variant of CREATE AGGREGATE
--- the information you need to specify to create a window function
is not at all like what you need to specify to create an aggregate.
        regards, tom lane