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

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 (view raw or flat)
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

pgsql-hackers by date

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

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