On Mon, Jun 06, 2011 at 11:33:35PM +0200, Sidney Cadot scratched on the wall:
> On Mon, Jun 6, 2011 at 9:55 PM, Jean-Christophe Deschamps
> <j...@antichoc.net> wrote:
> 
> > You have a DOUBLE column where you need to store NaN? ?Go ahead and
> > store 'NaN' in offending rows.
> 
> You mean, as a string?

  No, by binding the raw value using the C interfaces as any
  respectable program would do.
  
> Also, it doesn't work as it should:
>
> sqlite> SELECT 1.0 + 'NaN';
> 1.0

  Yes, well, it's been pretty clearly determined that SQLite doesn't
  deal with floating point numbers for your definition of "as it should."


   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to