Klaas Van B. wrote: " Indeed, in the page you refer to is missing the operator "<>" documented here: " " https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fsqlite.org%2Frowvalue.html%23syntax&data=02%7C01%7CStephan.Mueller%40microsoft.com%7C1581cbb9304944c7d4d208d496d91ad4%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636299306582232473&sdata=d8k9bPft6izHZBmEPqIgn2%2F%2FgWEcXkoXtPo06spwxGY%3D&reserved=0 " " Juan Francisco Benítez López wrote on Tue, 9 May 2017 12:35:38 +0200: " ">... ">"SQLite version 3 has the usual set of SQL comparison operators including ">"=", "==", "<", "<=", ">", ">=", "!=", "", "IN", "NOT IN", "BETWEEN", "IS", ">and "IS NOT", ." ">After the operator '!=' doesn't appear any operator. I suppose that the ">empty one is the operator '<>'. ">...
I believe Klaas and Juan are referring to different pages. On the page Juan cites (https://sqlite.org/datatype3.html), there is indeed an empty "" after "!=" -- perhaps the text <> was interpreted as an empty HTML tag at some processing step? The page Klaas references (http://sqlite.org/rowvalue.html#syntax) does include <>, but is missing == and !=. Mind you, Juan's page doesn't claim an exhaustive list -- just that the comparison operators are those "including" the given list (but the empty "" certainly seems unintentional.) Perhaps some minor edits to both pages are worthwhile. stephan(); _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users