prad writes:
> REGEXP requires definition of regexp()
> we seem to require C to do this:
> http://www.sqlite.org/lang_expr.html#regexp
>
> or
>
> apparently there is a sqlite3-pcre which adds
> /usr/lib/sqlite3/pcre.so
> and that does the trick.
>
> however, sqlite3-pcre doesn't seem to exist on debian.
>
> what is the recommended way of getting regexp to work?
>
well that was fast!
what i did was download the sqlite3-pcre from ubuntu here:
http://mirror.corbina.net/pub/Linux/ubuntu/pool/universe/s/sqlite3-pcre/
(i needed the amd64)
then since it was a deb file:
dpkg -i sqlite3-pcre_0~git20070120091816+4229ecc-0ubuntu1_amd64.deb
in sqlite you simply:
.load /usr/lib/sqlite3/pcre.so
and it all works!
--
in friendship,
prad
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users