So, if I understand correctly, SQLite does not support these two operators "out of the box". Is there an easy way to get user-defined functions for regexp and match? Or has no one developed those yet?
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] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------