Skip site navigation (1) Skip section navigation (2)

Re: TODO items for window functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec>
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 18:03:12
Message-ID: 9755.1230573792@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)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

In response to

pgsql-hackers by date

Next:From: Hitoshi HaradaDate: 2008-12-29 18:12:50
Subject: Re: TODO items for window functions
Previous:From: Hitoshi HaradaDate: 2008-12-29 18:02:38
Subject: Re: TODO items for window functions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group