index on regex

[dave_duke]

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.*’

etc

[Norman_Palardy]

probably not

from SQL Language Expressions

The REGEXP operator is a special syntax for the regexp() user function. No regexp() user function is defined by default and so use of the REGEXP operator will normally result in an error message. If an application-defined SQL function named “regexp” is added at run-time, then the “X REGEXP Y” operator will be implemented as a call to “regexp(Y,X)”.

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 - Views of a Coder: Xojo SQLite databases: Enabling ICU for full Unicode support and adding custom functions
dont think it adds a regexp though