> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 8:33 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] User function in WHERE clause > > "param MYFUNCTION Name" is equivalent to > "MYFUNCTION(Name, param)" onoly if MYFUNCTION > is one of: > > LIKE GLOB REGEXP MATCH > > Only LIKE and GLOB are defined by default. MATCH is > not in 3.3.6, but is in the source tree. > > Note that you can use sqlite3_create_function() to > replace the build-in LIKE or GLOB function to do > whatever it is you want. REGEXP is undefined, so you > can define it to do whatever you need, though as you > can probably guess, it is intended for regular > expression matching.
Ah that explains things a bit. I just happened to have overridden REGEXP without realizing it was pre-defined to allow you to call it that way. Am I mistaken, or did you recently check-in a patch that fixes the parameters so that "a REGEX b" is the same as "REGEX(a,b)" ? Robert
