Re: [sqlite] Retrieving NANs

2009-01-09 Thread Sander Jansen
On Thu, Jan 8, 2009 at 7:03 PM, Gerry Snyder wrote: > Sander Jansen wrote: >> I need to store NaNs in my database and able to retrieve them as well. >> >> Since sqlite will give me back 0.0 when I call sqlite3_column_double >> and a result contains a NAN, >> I was wondering what the best way is to

Re: [sqlite] Retrieving NANs

2009-01-08 Thread Gerry Snyder
Sander Jansen wrote: > I need to store NaNs in my database and able to retrieve them as well. > > Since sqlite will give me back 0.0 when I call sqlite3_column_double > and a result contains a NAN, > I was wondering what the best way is to retrieve a NAN from the database. > > Here's what I current

[sqlite] Retrieving NANs

2009-01-08 Thread Sander Jansen
I need to store NaNs in my database and able to retrieve them as well. Since sqlite will give me back 0.0 when I call sqlite3_column_double and a result contains a NAN, I was wondering what the best way is to retrieve a NAN from the database. Here's what I currently do in peudo code: if (sqlite3