For what it's worth, SQL2011 does define OFFSET, finally. Alex
On Tue, Mar 26, 2013 at 5:00 PM, Petite Abeille <[email protected]>wrote: > > On Mar 26, 2013, at 4:19 PM, Michael Manfre <[email protected]> wrote: > > > Maybe someday the non-standard LIMIT/OFFSET keywords will get added to > the > > standard (I truly hope this happens) so Oracle, MSSQL, DB2, and Informix > > could share SQL with postgres and mysql without needing to mangle it. > > FWIW, Oracle 12c is rumored to support OFFSET/FETCH FIRST: > > • Top-N now using Row limiting clause eg. “OFFSET 10 ROWS FETCH FIRST 10 > ROWS ONLY”. Similar to mySQL syntax. > > http://www.oracle-base.com/blog/2012/10/06/oracle-openworld-2012-day-5/ > > > -- > You received this message because you are subscribed to the Google Groups > "Django developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/django-developers?hl=en > . > For more options, visit https://groups.google.com/groups/opt_out. > > > -- "I disapprove of what you say, but I will defend to the death your right to say it." -- Evelyn Beatrice Hall (summarizing Voltaire) "The people's good is the highest law." -- Cicero -- You received this message because you are subscribed to the Google Groups "Django developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-developers?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
