This page gives an overview about the data types supported by Polypheny.
|Bigint||8 bytes signed (two’s complement). Ranges from |
|Boolean||1-bit. Takes the value |
|Date||Represents a date. Format: |
|Decimal||A decimal number is a number that can have a decimal point in it. This type has two arguments: precision and scale. The scale can not exceed the precision.|
|Double||8 bytes IEEE 754. Covers a range from |
|Integer||4 bytes, signed (two’s complement). Covers a range from |
|Real||4 bytes, IEEE 754. Covers a range from |
|Smallint||2 bytes, signed (two’s complement). Covers a range from |
|Time||Represents a time of day without time zone. Can optionally be defined with a fractional second precision between 0 and 3. Format: |
|Timestamp||Represents a combination of DATE and TIME values. Can optionally be defined with a fractional second precision between 0 and 3. Format: |
|Tinyint||1 byte, signed (two’s complement). Covers a range from |
|Varchar||String (can contain letters, numbers, and special characters) with variable length. The maximum length is specified as parameter.|
An array is an ordered, contiguous collection that may contain duplicates. Polypheny-DB supports arrays of all scalar types.
In Polypheny-DB, arrays can have an arbitrary dimension and cardinality. Both are specified as arguments. Specifying -1 disables validation.
The dimension specifies how deep arrays can be nested. A dimension of one therefore means that nested arrays are not allowed while a dimension of two allows nested arrays but no nested arrays within nested arrays.
The cardinality specifies the number of elements (values and nested arrays) in every (nested) array.