From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "Hitoshi Harada" <umi(dot)tanuki(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: TODO items for window functions |
Date: | 2008-12-29 17:30:59 |
Message-ID: | 3073cc9b0812290930m951607dy4030b6e9a19c52b9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Dec 29, 2008 at 11:59 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-12-29 17:35:47 | Re: TODO items for window functions |
Previous Message | Kurt Roeckx | 2008-12-29 17:26:34 | Re: Gcc 4.4 causes abort in plpython. |