I've noticed that I can use IEEE Infinity values in SQLite by writing any literal too big for a double.
sqlite> CREATE TABLE foo (x REAL); sqlite> INSERT INTO foo VALUES (9e999); -- +Inf sqlite> INSERT INTO foo VALUES (-9e999); -- -Inf sqlite> INSERT INTO foo VALUES (9e999 / 9e999); -- NaN: gets converted to NULL sqlite> .null NULL sqlite> select * FROM foo; Inf -Inf NULL sqlite> SELECT * FROM foo WHERE ABS(x) = 9e999; Inf -Inf Is it true on all platforms that 9e999 = Infinity and CAST(9e999 AS TEXT) = 'Inf'? What's the preferred SQL syntax for infinity? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
