Enum DuckDbValueKind
The kinds of values that can be read from or stored into DuckDB.
Namespace: Mallard
Assembly: Mallard.dll
Syntax
public enum DuckDbValueKindRemarks
The word "type" is deliberately avoided for the name of this enumeration
to avoid confusion with DuckDB's logical types, or .NET types.
(Nevertheless, in DuckDB's C API, this enumeration is called duckdb_type.)
This enumeration mostly specifies the physical representation of values
but not completely. For instance, decimal numbers in DuckDB vectors
are stored as integers with a width w, and number of decimal
digits for the fractional part of the number d, that
is specified when the type of the vector is defined as holding elements
of (logical) type DECIMAL(w,d). That supplementary information
is queried separately.
Fields
| Name | Description |
|---|---|
| Any | |
| Array | |
| BigInt | 64-bit signed integer: BIGINT (INT8, INT64, LONG) in DuckDB SQL. |
| Bit | Bit-strings: BITSTRING (BIT) in DuckDB SQL. |
| Blob | Blob (Binary Large Object): BLOB (BYTEA, BINARY, VARBINARY) in DuckDB SQL. |
| Boolean | Boolean values; BOOLEAN in DuckDB SQL. |
| Date | |
| Decimal | Fixed-point decimal numbers: DECIMAL (NUMERIC) in DuckDB SQL. |
| Double | Double-precision (64-bit) floating-point number: FLOAT (FLOAT8) in DuckDB SQL. |
| Enum | |
| Float | Single-precision (32-bit) floating-point number: FLOAT (FLOAT4, REAL) in DuckDB SQL. |
| HugeInt | 128-bit signed integer: HUGEINT (INT128) in DuckDB SQL. |
| Integer | 32-bit signed integer: INTEGER (INT4, INT32, INT, SIGNED) in DuckDB SQL. |
| IntegerLiteral | |
| Interval | |
| Invalid | |
| List | |
| Map | |
| SmallInt | 16-bit signed integer: SMALLINT (INT2, INT16, SHORT) in DuckDB SQL. |
| SqlNull | |
| StringLiteral | |
| Struct | |
| Time | |
| TimeNanoseconds | |
| TimeTz | |
| Timestamp | |
| TimestampMilliseconds | |
| TimestampNanoseconds | |
| TimestampSeconds | |
| TimestampTz | |
| TinyInt | 8-bit signed integer: TINYINT (INT1) in DuckDB SQL. |
| UBigInt | 64-bit unsigned integer: UBIGINT (UINT64) in DuckDB SQL. |
| UHugeInt | 128-bit unsigned integer: UHUGEINT (UINT128) in DuckDB SQL. |
| UInteger | 32-bit unsigned integer: UINTEGER (UINT32) in DuckDB SQL. |
| USmallInt | 16-bit unsigned integer: USMALLINT (UINT16) in DuckDB SQL. |
| UTinyInt | 8-bit unsigned integer: UTINYINT (UINT8) in DuckDB SQL. |
| Union | |
| Uuid | 128-bit UUID (Universally Unique Identifiers): UUID in DuckDB SQL. |
| VarChar | Text string: VARCHAR (CHAR, BPCHAR, STRING, TEXT) in DuckDB SQL. |
| VarInt | Variable-length integers: BIGNUM in DuckDB SQL. |