> On Fri, Jul 25, 2008 at 1:57 AM, paul POULAIN <[EMAIL PROTECTED]> > wrote: > > Please note that the SQL "LIMIT" pragma is mySQL specific. So it must be > avoided.
Paul, I'm not sure what gave you that impression. Maybe you are thinking of Oracle, where a "rownum" construction is used. (But not much I'm going to do is going to get us near running on Oracle.) In practice, the only other DB we've even seen work to support is postgres, so it should be sufficient to show that it supports limit clauses. It does: http://www.postgresql.org/docs/7/static/sql-select.htm Pg supports OFFSET also. I suspect Koha will move to a broader DBI management interface before Oracle is fully supported. In other words, I wouldn't change any queries for it, and certainly not for 3.0. I think there are plenty of uses of "LIMIT" in the code, and if this > is something we're working towards, I'll start eliminating them in any > code I work on. > Please don't, they are there for good reason! --joe
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
