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
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
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
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
--
> 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
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,
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); -- +
7 matches
Mail list logo