Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Yd5xI-0002fp-S7 for pgsql-docs@arkaria.postgresql.org; Tue, 31 Mar 2015 23:52:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Yd5xI-0002Ch-Aj for pgsql-docs@arkaria.postgresql.org; Tue, 31 Mar 2015 23:52:24 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yd5xG-0002Ag-Ur for pgsql-docs@postgresql.org; Tue, 31 Mar 2015 23:52:23 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Yd5xD-0000PA-QN for pgsql-docs@postgresql.org; Tue, 31 Mar 2015 23:52:21 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id t2VNqFnD014900; Tue, 31 Mar 2015 19:52:15 -0400 From: Tom Lane To: "David G. Johnston" cc: "pgsql-docs@postgresql.org" Subject: Re: ROW or RANGE not optional in range specification In-reply-to: References: Comments: In-reply-to "David G. Johnston" message dated "Tue, 31 Mar 2015 15:19:14 -0700" Date: Tue, 31 Mar 2015 19:52:15 -0400 Message-ID: <14899.1427845935@sss.pgh.pa.us> 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 "David G. Johnston" writes: > Either I'm confused about the syntax description rules or the documentation > for this aspect of window definitions is wrong. > The expression: > [ RANGE | ROWS ] BETWEEN frame_start AND frame_end > means that the specification of range or rows is optional - but that > doesn't appear to be the case... > The documentation should read: > { RANGE | ROWS } BETWEEN frame_start AND frame_end Yup, you're right. Thanks for spotting that! 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