Re: TODO items for window functions

On Mon, Dec 29, 2008 at 11:59 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I wrote:
>> * Support creation of user-defined window functions.  I think this is
>> a "must have" for 8.4 --- we are not in the habit of building
>> nonextensible basic features.  It doesn't seem that hard either.
>> I think all we need do is to allow "WINDOW" as an attribute keyword
>> in CREATE FUNCTION.  Does anyone have an objection or a better idea?
>
> What I had in mind when I wrote that was something like
>
>        create [or replace] function mywindow(...) returns ...
>                as 'mymodule, 'mywindow'
>                language c
>                window;
>

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...

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157