pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: winston cheung <winston_cheung@163.com>
To: pgsql-admin@postgresql.org
Subject: Re: windown function count Unexpected results
Date: Fri, 5 May 2017 19:10:04 +0800
Message-ID: <13010b9e-7d51-c17a-1202-7cc084df7d9e@163.com> (raw)
In-Reply-To: <CAEJt7k2S611CXKkcW-CiVkA-kyjtABtjNYqHD3ZM9b5koXYDRg@mail.gmail.com>
References: <eaec97a5-9412-7edc-15ff-c5c193649c75@163.com>
	<CAEJt7k3impue_aGOyOP+CYn_Pbpi3UOq8xKhSGWFcpEDV+hhvA@mail.gmail.com>
	<CAEJt7k2S611CXKkcW-CiVkA-kyjtABtjNYqHD3ZM9b5koXYDRg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

thanks a lot，steven，david :-)


在 5/5/17 13:14, Steven Chang 写道:
> Hello,
>
>      Official document in 
> https://www.postgresql.org/docs/9.3/static/functions-window.html says 
> so   :
> An aggregate used with ORDER BY and the default window frame 
> definition produces a "running sum" type of behavior, which may or may 
> not be what's wanted. To obtain aggregation over the whole partition, 
> omit ORDER BY or use ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED 
> FOLLOWING

winston , regards

view thread (5+ messages)

Message-ID: <13010b9e-7d51-c17a-1202-7cc084df7d9e@163.com>
Permalink:  ../13010b9e-7d51-c17a-1202-7cc084df7d9e@163.com/
Also on:    postgresql.org/message-id/13010b9e-7d51-c17a-1202-7cc084df7d9e@163.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: winston_cheung@163.com
  Subject: Re: windown function count Unexpected results
  In-Reply-To: <13010b9e-7d51-c17a-1202-7cc084df7d9e@163.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox