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

Re: Basic Requirements for SQL Window Functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Basic Requirements for SQL Window Functions
Date: 2004-11-29 16:41:13
Message-ID: 19224.1101746473@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> The SQL window functions seem to require an ordering for most of their
> operations.

AFAICS, the entire concept of a "window" implies the input is ordered
in some way; what operations would they provide that don't require this?

> It is possible that that could be provided by a sort node in
> the execution plan.

Either sort or indexscan, but you'd certainly need one or the other.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Greg StarkDate: 2004-11-29 17:21:06
Subject: Re: Stopgap solution for table-size-estimate updatingproblem
Previous:From: Gaetano MendolaDate: 2004-11-29 16:35:42
Subject: Re: Documentation on PITR still scarce

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