On Tue, 08 Dec 2009 12:11:13 -0500, li...@mgreg.com <li...@mgreg.com> wrote:
> Hi All, > > I'm currently using SQLITE in a few production apps. I'm using various > languages such as Ruby, PERL, RB, etc. I have need to use regular > expressions in some of my queries, but I'm not sure how to implement > "user defined functionality". Where are the hooks? Is there a > particular mechanism/language I must use to create them? Is this > something I'm required to recompile SQLITE for? You do so by defining a user function called 'regexp'. The means by which one defines a user function depends on the language. See, for instance, [1] for Ruby. For a 'regexp' function you would specify two arguments, pattern and string to match against. [1] <http://sqlite-ruby.rubyforge.org/sqlite3/classes/SQLite3/Database.html#M000115> -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
