From: Rolando Abarca <funkaster@...>
Date: 2008-01-16T05:01:54+09:00
Subject: sqlite regexp support

What's the Right Way(tm) to implement regexp support in sqlite?
I'm doing this, but apparently it's not working:

     db = SQLite3::Database.new("test.db")
     db.results_as_hash = true
     db.create_function('regexp', 2) do |func, v1, v2|
       r = Regexp.new(v1.to_s)
       if v2.to_s.match(r)
         func.result = true
       else
         func.result = false
       end
     end

and i'm running a query like this:

select * from table where column REGEXP '(www\.)?somedomain.com'

any hints?
what should return the regexp function?

-- 
Rolando Abarca
Phone: +56-9 97851962
My Amazon Wish List: http://www.amazon.com/gp/registry/wishlist/3AGJOT5E6SIQB