Joe Atzberger a écrit :
On Fri, Jul 25, 2008 at 1:57 AM, paul POULAIN <paul.poulain@biblibre.com <mailto:paul.poulain@biblibre.com>> 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