[GRASS-user] SQLite REGEXP

Glynn Clements glynn at gclements.plus.com
Wed Jul 4 07:45:03 EDT 2007


Neil Best wrote:

> Anyone out there have any insight on how to define a regexp() function
> for SQLite at run-time as described at
> http://www.sqlite.org/lang_expr.html#regexp

http://www.sqlite.org/capi3ref.html#sqlite3_create_function

This would need to be done in the driver (db/drivers/sqlite), probably
whenever a database is opened (db__driver_open_database, in db.c).

As for implementation: regcomp/regexec should be available on all Unix
systems, but you might need a separate library for Windows.

-- 
Glynn Clements <glynn at gclements.plus.com>




More information about the grass-user mailing list