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 <[EMAIL PROTECTED]> Project Analyst Lanworth, Inc. (formerly Forest One, Inc.) tel 630 250 8664 _______________________________________________ grassuser mailing list [email protected] http://grass.itc.it/mailman/listinfo/grassuser
