On Wednesday, 8 January, 2020 04:16, R Smith <ryansmit...@gmail.com> wrote:
>I find the keyword NOTNULL listed among known SQLite keywords - >no. 88 on this page: https://sqlite.org/lang_keywords.html >But cannot find a single mention of it or place to use it in SQLite, nor >get any hit on the sqlite.org search except in reference to the above >list. >1. What is it for? It is a common misspelling of "IS NOT NULL" and means the same thing. "ISNULL" is also a reserved word as it is a common misspelling of "IS NULL" and means the same thing. You will note that ISNOTNULL is not a reserved word because apparently the common misspellings only omit one or the other of the spaces, butnotboth at the sametime. Also, ISNOT is not a reserved word. Apparently it is more common for the misspelling IS NOTNULL to be made than ISNOT NULL, even though ISNOT is the more logical inverse operator to IS. (Perhaps this is because ISNOT could be spelled as iSnot leading to lawsuits from Apple ... :) ) >2. Does it have/need any documentation? No. -- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
