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

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |