NaN and Infinity in the SmallSQL Database

 

The SmallSQL Database supports the floating point values NaN and Infinity. This values can be saved in the data types REAL, FLOAT and DOUBLE. If you convert or cast it to a string data type then you receive the strings "Infinity" and "NaN". If you convert it to a fixed point data type then you receive the value 0 for NaN and the max value for Infinity.

see also:
Data Types
 

 

 

 

 


100% pure Java DBMS
Mirror Site