Re: [Modeling-users] Limit

[Jerome K. <Jer...@fi...>]

On Sat, Mar 01, 2003 at 02:15:07PM +0000, Sebastien Bigaret wrote:

[snip]

> * MySQL offers the very same syntax
>   http://www.mysql.com/doc/en/SELECT.html
> 
>   even if it's not clear to me if an ORDER BY clause is also required for
>   consistency between consecutive queries, but a few tries will show (I'll
>   appreciate if someone with a mysql server at hand could try and report)

This is right in fact in mysql if you don't have a 'ORDER BY' clause the server 
will use the insert ordering.

[snip]

 
> Back to the fetchLimit(): what do you all think about the proposal?
> 
> Implementing it for Postgresql and MySQL wouldn't be that hard, except that
> it will require support for SortOrderings on the SQL side --not done yet.

Yeah this sound great. 


Bye Bye :)