> On Jan 4, 2017, at 5:57 AM, R Smith <rsm...@rsweb.co.za> wrote: > > As I have it (and as is implemented by SQLite) the GLOB operator implements a > REGEXP that matches against a regexp pattern
No, these are NOT regular expressions in the usual sense of the word. GLOB's syntax is incompatible with what are commonly called “regular expressions”, and its feature set is a lot more limited. (It may technically implement a type of regular expression in the underlying algorithmic sense, but I think using the term is misleading.) Case in point: the string "*[^1-9]*" is illegal in every regex syntax I know of, because “*” is a postfix operator in regex and can’t appear at the start of the string. Thanks to Dr. Hipp for quoting the exact definition. It looks like this is basically the same syntax as the Unix glob(3) function, which is familiar to anyone who’s used a Unix shell. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users