Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Uko1Y-0007re-5F for pgsql-docs@arkaria.postgresql.org; Fri, 07 Jun 2013 04:11:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Uko1X-0004kz-Ly for pgsql-docs@arkaria.postgresql.org; Fri, 07 Jun 2013 04:11:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Uko1X-0004ku-5h for pgsql-docs@postgresql.org; Fri, 07 Jun 2013 04:11:35 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Uko1T-0002RI-U4 for pgsql-docs@postgresql.org; Fri, 07 Jun 2013 04:11:34 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id r574BUGf012796; Fri, 7 Jun 2013 00:11:30 -0400 (EDT) From: Tom Lane To: eggyknap cc: pgsql-docs@postgresql.org Subject: Re: Minor quibble with description of WINDOW clause In-reply-to: <51aeaae5.a5ac420a.05d9.4850@mx.google.com> References: <51aeaae5.a5ac420a.05d9.4850@mx.google.com> Comments: In-reply-to eggyknap message dated "Tue, 04 Jun 2013 21:05:57 -0600" Date: Fri, 07 Jun 2013 00:11:30 -0400 Message-ID: <12795.1370578290@sss.pgh.pa.us> X-Pg-Spam-Score: -2.4 (--) 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 eggyknap writes: > The way the WINDOW clause docs are currently worded, it's clear from the > grammar tree that such clauses come toward the end of the query. But this > phrase made me wonder, incorrectly, whether they were supposed to come before > calls to window functions, somehow: > "...where window_name is a name that can be referenced from subsequent window > definitions or OVER clauses" > See http://www.postgresql.org/docs/9.3/static/sql-select.html#SQL-WINDOW for > the full context. > I'd have preferred to see "...from OVER clauses or subsequent window > definitions", which the attached simple patch does. And if I'm the only one > that likes the idea of such a change, I'll gladly go away quietly. :) I think you're right. Applied and back-patched. regards, tom lane -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs