Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cwWkw-0003Ej-Lg for pgsql-docs@arkaria.postgresql.org; Fri, 07 Apr 2017 16:29:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cwWkw-00046k-5A for pgsql-docs@arkaria.postgresql.org; Fri, 07 Apr 2017 16:29:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cwWku-00045E-VD for pgsql-docs@postgresql.org; Fri, 07 Apr 2017 16:29:01 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cwWkr-0000uZ-Jq for pgsql-docs@postgresql.org; Fri, 07 Apr 2017 16:29:00 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1cwWko-0000zy-Uz; Fri, 07 Apr 2017 12:28:54 -0400 Date: Fri, 7 Apr 2017 12:28:54 -0400 From: Bruce Momjian To: Tom Lane Cc: PostgreSQL-documentation Subject: Re: Window function docs Message-ID: <20170407162854.GH5757@momjian.us> References: <20170406214918.GA5757@momjian.us> <15355.1491516824@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <15355.1491516824@sss.pgh.pa.us> User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org On Thu, Apr 6, 2017 at 06:13:44PM -0400, Tom Lane wrote: > avg() is going to be evaluated across the current frame, not the whole > partition. I don't mind trying to be more precise than "appropriate set", > but it doesn't help to be apparently precise but wrong. > > Not really convinced by the s/regular/normal/g changes. That doesn't seem > to clarify much either. Maybe it would help to define "normal" near here. > There's a definition in func.sgml (that they are not ordered-set or > hypothetical-set aggregates) but that's too far away. This change is not on my patch yes but what do you think about changing "regular" and "normal" aggregate designations to "generic"? That seems clearer because the aggregates work in non-window and window contexts. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription + -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs