prad <p...@towardsfreedom.com> 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