Re: [Firebird-docs] Deprecated ROWS ?

[Dmitry Y. <fir...@ya...>]

18.07.2010 14:24, GR wrote:

>> Moreover, the latest SQL specification
>> establishes new syntax for selecting row ranges,
>> so we might need to follow this.
>
> The third one? OMG...

Being honest, our ROWS syntax has been taken from the [imcomplete] draft 
of the windowing functions proposal, and also it has been simplified to 
follow the Interbase implementation. Since then, the ANSI committee has 
agreed to move the ORDER BY clause (and its ROWS capabilities) from the 
cursor definition to the generic query expression syntax. This is a 
noticeable step forward from the theoretical POV, but unfortunately, it 
means us to catch up in the practical term. Nothing urgent, I believe, 
just some syntax sugar to claim us as being compliant.


Dmitry