[GRASS-user] SQLite REGEXP

[Neil Best]

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 so that I can say things like:

echo "select foo from bar where baz REGEXP '^[Cc]'" | db.select

while using the sqlite driver for managing vector attributes?

Without taking any special action in 6.2.2cvs I get:

DBMI-SQLite driver error:
Error in sqlite3_prepare():select * from gtnotes2 where comments regexp
'^[Cc]orn'

no such function: regexp

Thanks.

Neil

--
Neil Best <nbest at lanworth.com>
Project Analyst
Lanworth, Inc. (formerly Forest One, Inc.)
tel 630 250 8664