db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lance J. Andersen" <Lance.Ander...@Sun.COM>
Subject Re: Question regarding DERBY-4208 Parameters ? with OFFSET and/or FETCH
Date Thu, 09 Jul 2009 17:37:15 GMT

Kathey Marsden wrote:
> Mike Matrigali wrote:
>> I would rather wait for an approved standard so that we don't later
>> get caught with apps depending on a non-standard behavior that we
>> might want to change in the future to meet a standard.
>> From the provided info it does not even look like there is a defacto
>> standard adopted by multiple db's.
> I  tend to agree that it is better to wait for a standard. This still 
> seems all over the place for the different database product 
> implementations and not yet even in a draft standard.
Well it is in the standard for 2008

<result offset clause> ::=
OFFSET <offset row count> { ROW | ROWS }
<fetch first clause> ::=
FETCH { FIRST | NEXT } [ <fetch first row count> ] { ROW | ROWS } ONLY

So why not support it?

personally, if you can easily support some of the other variants, i 
would do that as well.  Just because something is not in an official 
standard, it indirectly becomes a standard when implemented by multiple 

Don't get me wrong, standards are important, but so is making 
applications easier to use and migrate from one platform to another


> Kathey

View raw message