index on regex

I see from the sqlite documentation you can index on a regex , is this possible in Xojo’s sqlite3 wrapper

SELECT * FROM foobar WHERE pattern REGEXP ‘foo.*’


probably not


pretty sure xojo does not add a user written regexp function to the build of sqlite

EDIT : OH But Thomas T did have a means to add user written C functions to the default sqlite from xojo
let me find it

EDIT : this -
dont think it adds a regexp though