Create a table with FLOAT type
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?
Hi,
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., http://www.techonthenet.com/sql/datatypes.php
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 http://www.monetdb.org/Documentation/Manuals/SQLreference/BuiltinTypes
Best, Stefan
----- 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@monetdb.org https://www.monetdb.org/mailman/listinfo/developers-list
participants (2)
-
Adnan Agbaria
-
Stefan Manegold