| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Window functions patch v04 for the September commit fest |
| Date: | 2008-09-03 05:47:13 |
| Message-ID: | 1220420833.4371.613.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2008-09-02 at 15:51 +0300, Heikki Linnakangas wrote:
> The needs of access to the rows are so different that it seems best to
> me to delegate the buffering to the window function.
That seems sensible in some ways, not others.
Some of the window functions, like lead and lag merely specify window
size and shape for other functions to act upon. For those types of
request I don't see any need for custom functions, whereas for the
comparison/calculation functions there might be a need.
We don't need to implement all the things the SQL Standard calls window
functions with a 1:1 mapping to Postgres functions.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | daveg | 2008-09-03 06:17:24 | Re: IN vs EXISTS equivalence |
| Previous Message | Devrim GÜNDÜZ | 2008-09-03 04:07:50 | Re: make dist does not include man.tar.gz and postgres.tar.gz |