[Koha-devel] [Koha-patches] [PATCH] BUG-2393: ENHANCEMENT: SearchMember() uses "cardnumber%" wildcard - if other search-types fail

[Paul POULAIN]

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