Joe Atzberger a écrit : > > On Fri, Jul 25, 2008 at 1:57 AM, paul POULAIN > <[EMAIL PROTECTED] <mailto:[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.)
I never used Oracle, so I was not thinking about it ;-) > 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 OK, I didn't knew that. However, afaik, LIMIT is not SQL92 compliant, but I can live with that ;-) -- Paul POULAIN http://www.biblibre.com Expert en Logiciels Libres pour l'info-doc NOUVEAU TELEPHONE : 04 91 81 35 08 _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
