Data Types

SQL prescribes a large collection of built-in types, most of which are directly supported.

• Base Types (BOOLEAN, CHARACTER, INTEGER, DECIMAL, REAL, DOUBLE, FLOAT, BINARY LARGE OBJECT, etc)
• Temporal (DATE, TIME, TIMESTAMP, TIMESTAMP WITH TIME ZONE, INTERVAL MONTH, INTERVAL SECOND, etc)
• Serial (SERIAL, BIGSERIAL, AUTO_INCREMENT, GENERATED ALWAYS AS IDENTITY)
• IP address (inet, inet4, inet6)
• JSON
• URL
• UUID

Some domain specific data types (e.g. GeoSpatial) are not part of the MonetDB core, but are provided as an extension module which can be installed separately.

• GeoSpatial (Geometry, Point, Curve, LineString, Surface, Polygon, MultiPoint, MultiLineString, etc.)

The MonetDB database kernel can also be extended with User Defined Types to support application domain specific types and associated functions.