Create a table with FLOAT type

Stefan Manegold Stefan.Manegold at
Sun Jan 5 16:39:24 CET 2014


in the SQL standard,
REAL is a single-precision (32-bit/4-byte) floating point data type,
DOUBLE is a double-precision (64-bit/8-byte) floating point data type,
and FLOAT is a data type that might allow to specify the precision;
cf., e.g.,

In MonetDB, we do not support FLOAT with variable precision. Thus, we
choose the highes available precision by mapping FLOAT to DOUBLE.
If you prefer single-precision (32-bit/4-byte), please consider using
REAL instead.
See also


----- Original Message -----
> Hello,
> I use MonetDB in Ubuntu. When I create a table with FLOAT type, MonetDB
> created it as DOUBLE type.
> Why does MonetDB decide to change FLOAT to DOUBLE?
> How can I fix this?
> _______________________________________________
> developers-list mailing list
> developers-list at

| Stefan.Manegold at | DB Architectures   (DA) |
|  | Science Park 123 (L321) |
| +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |

More information about the developers-list mailing list