> However, '&' and '|' and '<<' and '>>' do not seem to be defined, either > there or in
Almost none of the operators are defined. All that section needs is a sentence at the start saying "The operators have the same meaning as ANSI C except as described below." > On Oct 6, 2017, at 11:31 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > > > On 6 Oct 2017, at 9:12am, Rowan Worth <row...@dug.com> wrote: > >> On 6 October 2017 at 15:42, <no...@null.net> wrote: >> >>> On Fri Oct 06, 2017 at 09:28:08AM +0200, Clemens Ladisch wrote: >>>> >>>> For boolean values, "a XOR b" = "a <> b". >>> >>> Is the <> operator documented somewhere? I can't find it in either of >>> these places: >> >> <> is SQL for "not equal to" (shout out to all the BASIC fans). It’s >> documented here: >> https://sqlite.org/lang_expr.html#binaryops > > That page says that '<>' means 'non-equals'. This is not the same as the > binary operation 'XOR' since 'non-equals' can yield only two values: true and > false. Experimentation shows … > > sqlite> SELECT 11 = 19; > 0 > sqlite> SELECT 11 <> 19; > 1 > sqlite> SELECT 11 | 19; > 27 > sqlite> SELECT 11 & 19; > 3 > > … that even for binary values the documentation is correct and that '<>' does > not mean 'XOR'. However, '&' and '|' and '<<' and '>>' do not seem to be > defined, either there or in > > <https://www.sqlite.org/datatype3.html#operators> > > I can’t find anywhere in SQLite’s own documentation that defines them. > Perhaps this should be remedied. > > Simon. > _______________________________________________ > 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