ADQL evolution: OFFSET?
Markus Demleitner
msdemlei at ari.uni-heidelberg.de
Fri Jan 22 10:14:59 CET 2016
Hi,
On Thu, Jan 21, 2016 at 03:25:05PM +0000, Mark Taylor wrote:
> On Thu, 21 Jan 2016, Walter Landry wrote:
>
> > Markus Demleitner <msdemlei at ari.uni-heidelberg.de> wrote:
> > > The result would be, for ADQL,
> > >
> > > <order_by_clause> ::=
> > > ORDER BY <sort_specification_list> <result offset clause>
> > > <result offset clause> ::=
> > > OFFSET <unsigned integer>
> > >
> > > -- which is a relevant simplification, in particular restricting
> > > ourselves to unsigned integers, but I propose that's a good idea.
> > > Dropping the ROW[S], however, makes this not even a proper subset of
> > > SQL 2008. So, if anyone stands up and says "let's keep the ROW[S]",
> > > I'll have no choice but to concur.
> >
> > Let's keep the ROW[S]. We should not make it gratuitously different
> > from SQL.
>
> Yeah. Instead of the reek of COBOL, try thinking of it as retro chic.
That certainly makes it more palatable, yes. So, it would be
<order_by_clause> ::=
ORDER BY <sort_specification_list> [ <result offset clause> ]
<result offset clause> ::=
OFFSET <unsigned integer> (ROW|ROWS)
(note: original proposal was missing the square brackets).
Dave -- do you maintain the ADQL grammar? Where would that go?
Cheers,
Markus
More information about the dal
mailing list