Hi,
i hope I'm not overlooking something obvious, but the last result below
is not what I would expect. Just wondering if this could somehow be
correct and, if so, how to understand it.
regards,
Mark
$ sqlite3
SQLite version 3.15.1 2016-11-04 12:08:49
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> SELECT (2,2) BETWEEN (1,1) AND (3,3);
1
sqlite> SELECT (SELECT 2,2) BETWEEN (1,1) AND (3,3);
1
sqlite> SELECT 1 WHERE (SELECT 2,2) BETWEEN (1,1) AND (3,3);
1
sqlite> SELECT 1 WHERE (2,2) >= (1,1) AND (2,2) <= (3,3);
1
sqlite> SELECT 1 WHERE (2,2) BETWEEN (1,1) AND (3,3);
sqlite>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
