Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> The SQL window functions seem to require an ordering for most of their
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 Stark||Date: 2004-11-29 17:21:06|
|Subject: Re: Stopgap solution for table-size-estimate updatingproblem|
|Previous:||From: Gaetano Mendola||Date: 2004-11-29 16:35:42|
|Subject: Re: Documentation on PITR still scarce|