On Sat, 10 Feb 2007 03:43:47 +0100, Rick wrote: >So, if I understand correctly, SQLite does not support >these two operators "out of the box".
Right. >Is there an easy way to get user-defined functions for regexp and match? Or >has no one developed those yet? Five days ago Wayne Bloss mentioned the Arke Systems sqlite3 dll MSVC project/source as a starting point to make a compatible extensions dll. Message-ID: <[EMAIL PROTECTED]> Four days ago Mikey C published an extension library in this list. Message-ID: <[EMAIL PROTECTED]> or http://www.nabble.com/Extension-functions-for-SQLite-in-C-for-free-tf3182921.html#a8833684 >Regards, >Rick van der Lans > >-----Oorspronkelijk bericht----- >Van: Kees Nuyt [mailto:[EMAIL PROTECTED] >Verzonden: Friday, February 09, 2007 10:55 PM >Aan: sqlite-users@sqlite.org >Onderwerp: Re: [sqlite] How do I get MATCH and REGEXP > > >On Fri, 9 Feb 2007 21:11:31 +0100, Rick wrote: > >>The manual mentions the support for the MATCH and the REGEXP operators. But >>if I use it, it doesn't work. Do I have to do something special to install >>those operators? > >http://www.sqlite.org/lang_expr.html tells: > >"The REGEXP operator is a special syntax for the regexp() user >function. No regexp() user function is defined by default and so >use of the REGEXP operator will normally result in an error >message. If a user-defined function named "regexp" is added at >run-time, that function will be called in order to implement the >REGEXP operator. > >The MATCH operator is a special syntax for the match() user >function. The default match() function implementation raises and >exception and is not really useful for anything. But extensions >can override the match() function with more helpful logic." > >>Regards, >>Rick van der Lans > >HTH -- ( Kees Nuyt ) c[_] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
