[sqlite] escape sequences for GLOB

2012-10-17 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: http://osdir.com/ml/sqlite-users/2012-

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

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 matching in SQLite ? > > I've al

Re: [sqlite] escape sequences for GLOB

2012-10-18 Thread Tristan Van Berkom
On 10/18/2012 09:26 PM, Richard Hipp wrote: 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 pa