Re: ROW or RANGE not optional in range specification

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-docs(at)postgresql(dot)org" <pgsql-docs(at)postgresql(dot)org>
Subject: Re: ROW or RANGE not optional in range specification
Date: 2015-03-31 23:52:15
Message-ID: 14899.1427845935@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

"David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> 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

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2015-04-01 20:52:48 Re: libpq "service" parameter not documented as not allowed inside a pg_service file
Previous Message David G. Johnston 2015-03-31 22:19:14 ROW or RANGE not optional in range specification