ADQL evolution: OFFSET?

Walter Landry wlandry at caltech.edu
Thu Jan 21 16:11:56 CET 2016


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.

Cheers,
Walter Landry


More information about the dal mailing list