Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8190=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1Yd4VH-0007rm-Mt
 for pgsql-docs@arkaria.postgresql.org; Tue, 31 Mar 2015 22:19:23 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M8190=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1Yd4VG-0003ed-HQ
 for pgsql-docs@arkaria.postgresql.org; Tue, 31 Mar 2015 22:19:22 +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 <david.g.johnston@gmail.com>)
 id 1Yd4VF-0003eO-Am
 for pgsql-docs@postgresql.org; Tue, 31 Mar 2015 22:19:21 +0000
Received: from mail-ie0-x236.google.com ([2607:f8b0:4001:c03::236])
 by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <david.g.johnston@gmail.com>)
 id 1Yd4VA-00079N-Vp
 for pgsql-docs@postgresql.org; Tue, 31 Mar 2015 22:19:20 +0000
Received: by iedm5 with SMTP id m5so28815979ied.3
 for <pgsql-docs@postgresql.org>; Tue, 31 Mar 2015 15:19:14 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:date:message-id:subject:from:to:content-type;
 bh=HcyTxoLHLy4IAppivysmCwyPtEDaDC3wAFr1FJeSA84=;
 b=iC2E+irUIb/DJaA6p6PEp07tJPHrynMmIBVjmOQjixf/sfUyBdgHx5FzPMFVHq91TI
 NgU7pfXceAOOkC3lBFRfYa8ICWxiJlI5OfDdxvbWc0+jRFU78RVxpyqA2rI737v/DOed
 Jc0wk10WwREtKWmirGEhSWAuyTw4wCI7MO3gu5acWrbxRfjpkdHuUX114tCPlOlD3Viy
 O7XBfgOdvboRqSTzMsg/QM+MxqHliz3BduzxJsE8+zpNhgciwVkJlbX1IJ5BYD2mjG9Z
 cx8IbbEu5b1otQIDwstUMYGtrUICC1umudJ1I36Gv66kD5MsgyQNt3KlioGFjTXatfdL
 NlOQ==
MIME-Version: 1.0
X-Received: by 10.107.170.87 with SMTP id t84mr19548882ioe.2.1427840354166;
 Tue, 31 Mar 2015 15:19:14 -0700 (PDT)
Received: by 10.36.78.80 with HTTP; Tue, 31 Mar 2015 15:19:14 -0700 (PDT)
Date: Tue, 31 Mar 2015 15:19:14 -0700
Message-ID: 
 <CAKFQuwYJk-hHqzOC_QFREZzurfqEAKXvmNk71tYOTTcrZGY_KQ@mail.gmail.com>
Subject: ROW or RANGE not optional in range specification
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
Content-Type: multipart/alternative; boundary=001a11415cc81b30a605129cfd4c
X-Pg-Spam-Score: -2.7 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

--001a11415cc81b30a605129cfd4c
Content-Type: text/plain; charset=UTF-8

http://www.postgresql.org/docs/devel/static/sql-select.html

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

Same goes for the bare frame_start specification preceding the between
version.

The bare version looks funny without tag but "ORDER BY idx BETWEEN 5
PRECEDING AND CURRENT ROW" isn't obviously wrong until you get a syntax
error...

David J.

--001a11415cc81b30a605129cfd4c
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style><font face=3D"arial, he=
lvetica, sans-serif"><a href=3D"http://www.postgresql.org/docs/devel/static=
/sql-select.html">http://www.postgresql.org/docs/devel/static/sql-select.ht=
ml</a></font><br></div><div class=3D"gmail_default" style><font face=3D"ari=
al, helvetica, sans-serif"><br></font></div><div class=3D"gmail_default" st=
yle><font face=3D"arial, helvetica, sans-serif">Either I&#39;m confused abo=
ut the syntax description rules or the documentation for this aspect of win=
dow definitions is wrong.</font></div><div class=3D"gmail_default" style><f=
ont face=3D"arial, helvetica, sans-serif"><br></font></div><div class=3D"gm=
ail_default" style><font face=3D"arial, helvetica, sans-serif">The expressi=
on:</font></div><div class=3D"gmail_default" style><font face=3D"arial, hel=
vetica, sans-serif"><br></font></div><div class=3D"gmail_default" style><fo=
nt face=3D"arial, helvetica, sans-serif">[ RANGE | ROWS ]=C2=A0=C2=A0BETWEE=
N frame_start AND frame_end</font></div><div class=3D"gmail_default" style>=
<font face=3D"arial, helvetica, sans-serif"><br></font></div><div class=3D"=
gmail_default" style><font face=3D"arial, helvetica, sans-serif">means that=
 the specification of range or rows is optional - but that doesn&#39;t appe=
ar to be the case...</font></div><div class=3D"gmail_default" style><font f=
ace=3D"arial, helvetica, sans-serif"><br></font></div><div class=3D"gmail_d=
efault" style><font face=3D"arial, helvetica, sans-serif">The documentation=
 should read:</font></div><div class=3D"gmail_default" style><font face=3D"=
arial, helvetica, sans-serif"><br></font></div><div class=3D"gmail_default"=
 style><font face=3D"arial, helvetica, sans-serif">{ RANGE | ROWS } BETWEEN=
 frame_start AND frame_end</font></div><div class=3D"gmail_default" style><=
font face=3D"arial, helvetica, sans-serif"><br></font></div><div class=3D"g=
mail_default" style><font face=3D"arial, helvetica, sans-serif">Same goes f=
or the bare frame_start specification preceding the between version.</font>=
</div><div class=3D"gmail_default" style><font face=3D"arial, helvetica, sa=
ns-serif"><br></font></div><div class=3D"gmail_default" style><font face=3D=
"arial, helvetica, sans-serif">The bare version looks funny without tag but=
 &quot;ORDER BY idx BETWEEN 5 PRECEDING AND CURRENT ROW&quot; isn&#39;t obv=
iously wrong until you get a syntax error...</font></div><div class=3D"gmai=
l_default" style><font face=3D"arial, helvetica, sans-serif"><br></font></d=
iv><div class=3D"gmail_default" style><font face=3D"arial, helvetica, sans-=
serif">David J.</font></div><div class=3D"gmail_default" style><font face=
=3D"arial, helvetica, sans-serif"><br></font></div></div>

--001a11415cc81b30a605129cfd4c--