Postgres Pro
Downloads
Home   >   mailing lists

Re: ROW or RANGE not optional in range specification - Mailing list pgsql-docs

From Tom Lane
Subject Re: ROW or RANGE not optional in range specification
Date
Msg-id 14899.1427845935@sss.pgh.pa.us
Whole thread Raw
In response to ROW or RANGE not optional in range specification  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-docs
Tree view 
"David G. Johnston" <david.g.johnston@gmail.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

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: ROW or RANGE not optional in range specification
Next
From: Bruce Momjian
Date:
Subject: Re: libpq "service" parameter not documented as not allowed inside a pg_service file