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:
|