ADQL evolution: OFFSET?
gerard.lemson at gmail.com
gerard.lemson at gmail.com
Tue Jan 12 16:43:19 CET 2016
Hi list
Just wanted to voice my support for Mark's use case, which is exactly the
way I use TOP: to see an example of the data, generally used without
ordering.
>
> > In terms of whether OFFSET makes sense without ORDER BY: I think
> > that's really a moot point since ADQL has allowed TOP without ORDER BY
> > since the beginning, which is exactly as questionable. So, I'd claim
>
> I don't think that's really true. TOP is just if you want a result but
you don't want
> it too big. Non-ORDERed OFFSET would on the other hand presumably be used
> to provide pagination. The problem there is that you might get different
> orderings for different queries, so end up with duplicate or missing
records.
>
Gerard
> --
> Mark Taylor Astronomical Programmer Physics, Bristol University, UK
> m.b.taylor at bris.ac.uk +44-117-9288776 http://www.star.bris.ac.uk/~mbt/
More information about the dal
mailing list