David,
Yes. That would be a big assist. I am new to using SQLite3 and found the
GLOB function erratic in practice -- not on SQLite3 but on other web
sites using SQLite. They yielded completely opposite results.
Second the motion.
Ken
On 01/05/2017 05:23 PM, dandl wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
