Re: [sqlite] escape sequences for GLOB

2012-10-18 Thread Richard Hipp
On Thu, Oct 18, 2012 at 2:28 AM, Tristan Van Berkom 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

Re: [sqlite] escape sequences for GLOB

2012-10-18 Thread Clemens Ladisch
Tristan Van Berkom wrote: > What is the proper default escape sequence to be used for GLOB > pattern matching in SQLite ? There are different escape mechanisms for different characters. A comment hidden in the source code explains: | Globbing rules: | | '*' Matches any sequence of zero

[sqlite] escape sequences for GLOB

2012-10-18 Thread Tristan Van Berkom
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: