From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin
>>>They’re probably using the external function interface to override the >>>internal globbing function. And by the look of the results at least one of >>>the programmers involved thinks that GLOB and REGEX do the same thing. I think you're right. One of the contributing problems is that the behaviour of GLOB is not defined in the documentation. Here is all it says: "The GLOB operator is similar to LIKE but uses the Unix file globbing syntax for its wildcards. Also, GLOB is case sensitive, unlike LIKE. Both GLOB and LIKE may be preceded by the NOT keyword to invert the sense of the test. The infix GLOB operator is implemented by calling the function glob(Y,X) and can be modified by overriding that function." Unix globbing for Linux is defined here: http://man7.org/linux/man-pages/man7/glob.7.html. AFAICT Sqlite does not implement this behaviour. Perhaps some accurate documentation for GLOB in Sqlite would help to clarify things? Regards David M Bennett FACS Andl - A New Database Language - andl.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users