Re: [sqlite] Infinity

ite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Michael Chen > Sent: Monday, October 19, 2009 11:40 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Infinity > > Thanks John. After incorporate a few changes, the code

Re: [sqlite] Infinity

will be different than max(). Sorry for the mistake. John -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Michael Chen Sent: Monday, October 19, 2009 11:40 PM To: General Discussion of SQLite Database Subject: Re: [sqlite

Re: [sqlite] Infinity

Thanks John. After incorporate a few changes, the code can compile and run. The result seems reasonable, the input infinity std::numeric_limits::max() is sent to and retrieved from a sqlite3 database correctly. --terminal output sqlite3 tempdb sqlite> select * from tl; 1.1 1.79769313486232e+308

Re: [sqlite] Infinity

-users-boun...@sqlite.org] On Behalf Of Michael Chen Sent: Monday, October 19, 2009 4:59 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Infinity //Dear there, it seems that I cannot insert std::numeric_limits::max(). I am on Mac Osx 10.5 //anybody can take a look at the code? I

Re: [sqlite] Infinity

n...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Michael Chen > Sent: Sunday, October 18, 2009 4:19 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Infinity > > > I am looking for the answer too. anybody know it? > > On S

Re: [sqlite] Infinity

qlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Michael Chen Sent: Sunday, October 18, 2009 4:19 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Infinity I am looking for the answer too. anybody know it? On Sat, Oct 17, 2009 at

Re: [sqlite] Infinity

I am looking for the answer too. anybody know it? On Sat, Oct 17, 2009 at 12:23 AM, Dan Bishop 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

[sqlite] Infinity

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