Re: sum() over (partition by order) question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: sum() over (partition by order) question
Date: 2008-12-31 21:36:27
Message-ID: 15528.1230759387@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
> I didn't expect so ORDER can change result of function sum.

Read the stuff about window frames. The results you show are
exactly per spec.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-12-31 21:45:57 Re: reloptions and toast tables
Previous Message Pavel Stehule 2008-12-31 21:34:08 sum() over (partition by order) question