I am looking for the answer too. anybody know it? On Sat, Oct 17, 2009 at 12:23 AM, Dan Bishop <danbisho...@gmail.com> wrote:
> 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 > -- Best regards, Michael Chen Google Voice Phone.: 847-448-0647 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
