Re: [sqlite] Infinity

2009-10-20 Thread Michael Chen
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 can compile and > run. > The resu

Re: [sqlite] Infinity

2009-10-19 Thread John Crenshaw
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

2009-10-19 Thread Michael Chen
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

2009-10-19 Thread John Crenshaw
qlite-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 co

Re: [sqlite] Infinity

2009-10-19 Thread Michael Chen
-- > From: sqlite-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 t

Re: [sqlite] Infinity

2009-10-18 Thread John Crenshaw
ge- From: sqlite-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,

Re: [sqlite] Infinity

2009-10-18 Thread Michael Chen
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 foo VALUES (9e999); -- +