Jason Tudor wrote: > I am trying to enable the REGEXP operator. I have read on the forums that > you must use the sqlite3_create_function. I would like to use the boost > regular expressions library under the hood. Question is, does anyone have > an example using this function (sqlite3_create_function) to override > regexp()? >
I haven't seem one, but your can look at the source for the LIKE and GLOB operators in the source file func.c at http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/func.c&v=1.191 The REGEXP operator will need to use the same sqlite API functions to implement its operation. It will need to get its arguments, perform the comparison,and return a result the same way. Once implemented you will need to register your function so sqlite wil call it when it parses a REGEXP operator in an SQL statement. You can see how SQLite registers it builtin functions in the source as well. It uses the same API's you will use. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
