On 10/18/2012 09:26 PM, Richard Hipp wrote:
On Thu, Oct 18, 2012 at 2:28 AM, Tristan Van Berkom <trista...@openismus.com
wrote:
Hi all,
I've been around and around the documentation, run a sequence of
test cases and still haven't figured this out.
What is the proper default escape sequence to be used for GLOB
pattern matching in SQLite ?
I've already read in this other thread:
http://osdir.com/ml/sqlite-**users/2012-06/msg00349.html<http://osdir.com/ml/sqlite-users/2012-06/msg00349.html>
That the ESCAPE keyword cannot be used to override the
default escape sequences used in GLOB, but how do I just
get by with defaults ?
The only characters that need escaping are *, ?, and [, and they can all be
escaped by making them into a one-character character class: [*], [?], and
[[].
Thanks a lot Clemens and Richard, Both replies were very helpful !
Cheers,
-Tristan
If this simply cannot be done, I'd really appreciate if
someone could point me in the right direction here, must
I override the 'glob' function in C code ?
If so, that's really not a problem as I'm running this
from C code anyway... but what should I override it with ?
Best Regards,
-Tristan
______________________________**_________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users