DuckDB v0.10.1 for Pascal

The Pascal API structure aligns with C++ DuckDB v0.10.1.

Record Value

Description
Hierarchy
Fields
Methods
Properties

Unit

ddb

Declaration

type Value = record

Description

Class: Value of ddb

Overview

Fields

Public o: Pduckdb_Value;

Methods

Public constructor FromNativePointer(ptr : Pduckdb_Value);
Public class operator Explicit(const r: Value): Boolean;
Public procedure AutoRelease();
Public class operator Implicit(const s: Double): Value;
Public class operator Implicit(const s: Int64): Value;
Public class operator Implicit(const s: Integer): Value;
Public class operator Implicit(const s: PUTF8Char): Value;
Public class operator Implicit(const s: Pointer): Value;
Public class operator Implicit(const s: Single): Value;
Public class operator Implicit(const s: string): Value;
Public procedure Init(arg1: LogicalType); overload;
Public procedure Init(); overload;
Public procedure Init(arg1: Integer); overload;
Public procedure Init(arg1: Int64); overload;
Public procedure Init(arg1: Single); overload;
Public procedure Init(arg1: Double); overload;
Public procedure Init(arg1: PUTF8Char); overload;
Public procedure Init(arg1: Pointer); overload;
Public procedure Init(arg1: string_t); overload;
Public procedure Init(arg1: str); overload;
Public procedure Init(arg1: Value); overload;
Public function GetTypeMutable(): LogicalType; overload;
Public function type(): LogicalType; overload;
Public function IsNull(): Boolean; overload;
Public class function MinimumValue(arg1: LogicalType): Value; overload; static;
Public class function MaximumValue(arg1: LogicalType): Value; overload; static;
Public class function NegativeInfinity(arg1: LogicalType): Value; overload; static;
Public class function Infinity(arg1: LogicalType): Value; overload; static;
Public class function Numeric(arg1: LogicalType; arg2: Int64): Value; overload; static;
Public class function Numeric(arg1: LogicalType; arg2: hugeint_t): Value; overload; static;
Public class function Numeric(arg1: LogicalType; arg2: uhugeint_t): Value; overload; static;
Public class function BOOLEAN(arg1: Shortint): Value; overload; static;
Public class function TINYINT(arg1: Shortint): Value; overload; static;
Public class function SMALLINT(arg1: Smallint): Value; overload; static;
Public class function INTEGER(arg1: Integer): Value; overload; static;
Public class function BIGINT(arg1: Int64): Value; overload; static;
Public class function UTINYINT(arg1: Byte): Value; overload; static;
Public class function USMALLINT(arg1: Word): Value; overload; static;
Public class function UINTEGER(arg1: Cardinal): Value; overload; static;
Public class function UBIGINT(arg1: UInt64): Value; overload; static;
Public class function HUGEINT(arg1: hugeint_t): Value; overload; static;
Public class function UHUGEINT(arg1: uhugeint_t): Value; overload; static;
Public class function UUID(arg1: str): Value; overload; static;
Public class function UUID(arg1: hugeint_t): Value; overload; static;
Public class function HASH(arg1: UInt64): Value; overload; static;
Public class function POINTER(arg1: PUIntPtr): Value; overload; static;
Public class function DATE(arg1: date_t): Value; overload; static;
Public class function DATE(arg1: Integer; arg2: Integer; arg3: Integer): Value; overload; static;
Public class function TIME(arg1: dtime_t): Value; overload; static;
Public class function TIMETZ(arg1: dtime_tz_t): Value; overload; static;
Public class function TIME(arg1: Integer; arg2: Integer; arg3: Integer; arg4: Integer): Value; overload; static;
Public class function TIMESTAMP(arg1: date_t; arg2: dtime_t): Value; overload; static;
Public class function TIMESTAMP(arg1: timestamp_t): Value; overload; static;
Public class function TIMESTAMPNS(arg1: timestamp_t): Value; overload; static;
Public class function TIMESTAMPMS(arg1: timestamp_t): Value; overload; static;
Public class function TIMESTAMPSEC(arg1: timestamp_t): Value; overload; static;
Public class function TIMESTAMPTZ(arg1: timestamp_t): Value; overload; static;
Public class function TIMESTAMP(arg1: Integer; arg2: Integer; arg3: Integer; arg4: Integer; arg5: Integer; arg6: Integer; arg7: Integer): Value; overload; static;
Public class function INTERVAL(arg1: Integer; arg2: Integer; arg3: Int64): Value; overload; static;
Public class function INTERVAL(arg1: interval_t): Value; overload; static;
Public class function ENUM(arg1: UInt64; arg2: LogicalType): Value; overload; static;
Public class function DECIMAL(arg1: Smallint; arg2: Byte; arg3: Byte): Value; overload; static;
Public class function DECIMAL(arg1: Integer; arg2: Byte; arg3: Byte): Value; overload; static;
Public class function DECIMAL(arg1: Int64; arg2: Byte; arg3: Byte): Value; overload; static;
Public class function DECIMAL(arg1: hugeint_t; arg2: Byte; arg3: Byte): Value; overload; static;
Public class function FLOAT(arg1: Single): Value; overload; static;
Public class function DOUBLE(arg1: Double): Value; overload; static;
Public class function STRUCT(arg1: duckdb_vector_std_pair_std_string_duckdb_Value__true): Value; overload; static;
Public class function STRUCT(arg1: LogicalType; arg2: vector_Value): Value; overload; static;
Public class function LIST(arg1: vector_Value): Value; overload; static;
Public class function LIST(arg1: LogicalType; arg2: vector_Value): Value; overload; static;
Public class function EMPTYLIST(arg1: LogicalType): Value; overload; static;
Public class function ARRAY(arg1: vector_Value): Value; overload; static;
Public class function ARRAY(arg1: LogicalType; arg2: vector_Value): Value; overload; static;
Public class function EMPTYARRAY(arg1: LogicalType; arg2: Cardinal): Value; overload; static;
Public class function MAP(arg1: LogicalType; arg2: vector_Value): Value; overload; static;
Public class function MAP(arg1: LogicalType; arg2: LogicalType; arg3: vector_Value; arg4: vector_Value): Value; overload; static;
Public class function UNION(arg1: duckdb_vector_std_pair_std_string_duckdb_LogicalType__true; arg2: Byte; arg3: Value): Value; overload; static;
Public class function BLOB(arg1: PByte; arg2: UInt64): Value; overload; static;
Public class function BLOB_RAW(arg1: str): Value; overload; static;
Public class function BLOB(arg1: str): Value; overload; static;
Public class function BIT(arg1: PByte; arg2: UInt64): Value; overload; static;
Public class function BIT(arg1: str): Value; overload; static;
Public class function AGGREGATE_STATE(arg1: LogicalType; arg2: PByte; arg3: UInt64): Value; overload; static;
Public function Copy(): Value; overload;
Public function Hash(): UInt64; overload;
Public function ToString(): str; overload;
Public function ToSQLString(): str; overload;
Public function GetPointer(): PUIntPtr; overload;
Public function CastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType; arg5: Boolean): Value; overload;
Public function CastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType): Value; overload;
Public function CastAs(arg2: ClientContext; arg3: LogicalType; arg4: Boolean): Value; overload;
Public function CastAs(arg2: ClientContext; arg3: LogicalType): Value; overload;
Public function DefaultCastAs(arg2: LogicalType; arg3: Boolean): Value; overload;
Public function DefaultCastAs(arg2: LogicalType): Value; overload;
Public function TryCastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType; arg5: Value; arg6: str; arg7: Boolean): Boolean; overload;
Public function TryCastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType; arg5: Value; arg6: str): Boolean; overload;
Public function TryCastAs(arg2: ClientContext; arg3: LogicalType; arg4: Value; arg5: str; arg6: Boolean): Boolean; overload;
Public function TryCastAs(arg2: ClientContext; arg3: LogicalType; arg4: Value; arg5: str): Boolean; overload;
Public function DefaultTryCastAs(arg2: LogicalType; arg3: Value; arg4: str; arg5: Boolean): Boolean; overload;
Public function DefaultTryCastAs(arg2: LogicalType; arg3: Value; arg4: str): Boolean; overload;
Public function TryCastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType; arg5: Boolean): Boolean; overload;
Public function TryCastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType): Boolean; overload;
Public function TryCastAs(arg2: ClientContext; arg3: LogicalType; arg4: Boolean): Boolean; overload;
Public function TryCastAs(arg2: ClientContext; arg3: LogicalType): Boolean; overload;
Public function DefaultTryCastAs(arg2: LogicalType; arg3: Boolean): Boolean; overload;
Public function DefaultTryCastAs(arg2: LogicalType): Boolean; overload;
Public procedure Reinterpret(arg2: LogicalType); overload;
Public procedure Serialize(arg2: Serializer); overload;
Public class function Deserialize(arg1: Deserializer): Value; overload; static;
Public class function FloatIsFinite(arg1: Single): Boolean; overload; static;
Public class function DoubleIsFinite(arg1: Double): Boolean; overload; static;
Public class function StringIsValid(arg1: PUTF8Char; arg2: UInt64): Boolean; overload; static;
Public class function StringIsValid(arg1: str): Boolean; overload; static;
Public class function ValuesAreEqual(arg1: CastFunctionSet; arg2: GetCastFunctionInput; arg3: Value; arg4: Value): Boolean; overload; static;
Public class function ValuesAreEqual(arg1: ClientContext; arg2: Value; arg3: Value): Boolean; overload; static;
Public class function DefaultValuesAreEqual(arg1: Value; arg2: Value): Boolean; overload; static;
Public class function NotDistinctFrom(arg1: Value; arg2: Value): Boolean; overload; static;
Public procedure Print(); overload;

Description

Fields

Public o: Pduckdb_Value;

This item has no description.

Methods

Public constructor FromNativePointer(ptr : Pduckdb_Value);

This item has no description.

Public class operator Explicit(const r: Value): Boolean;

This item has no description.

Public procedure AutoRelease();

This item has no description.

Public class operator Implicit(const s: Double): Value;

This item has no description.

Public class operator Implicit(const s: Int64): Value;

This item has no description.

Public class operator Implicit(const s: Integer): Value;

This item has no description.

Public class operator Implicit(const s: PUTF8Char): Value;

This item has no description.

Public class operator Implicit(const s: Pointer): Value;

This item has no description.

Public class operator Implicit(const s: Single): Value;

This item has no description.

Public class operator Implicit(const s: string): Value;

This item has no description.

Public procedure Init(arg1: LogicalType); overload;

This item has no description.

Public procedure Init(); overload;

This item has no description.

Public procedure Init(arg1: Integer); overload;

This item has no description.

Public procedure Init(arg1: Int64); overload;

This item has no description.

Public procedure Init(arg1: Single); overload;

This item has no description.

Public procedure Init(arg1: Double); overload;

This item has no description.

Public procedure Init(arg1: PUTF8Char); overload;

This item has no description.

Public procedure Init(arg1: Pointer); overload;

This item has no description.

Public procedure Init(arg1: string_t); overload;

This item has no description.

Public procedure Init(arg1: str); overload;

This item has no description.

Public procedure Init(arg1: Value); overload;

This item has no description.

Public function GetTypeMutable(): LogicalType; overload;

This item has no description.

Public function type(): LogicalType; overload;

This item has no description.

Public function IsNull(): Boolean; overload;

This item has no description.

Public class function MinimumValue(arg1: LogicalType): Value; overload; static;

This item has no description.

Public class function MaximumValue(arg1: LogicalType): Value; overload; static;

This item has no description.

Public class function NegativeInfinity(arg1: LogicalType): Value; overload; static;

This item has no description.

Public class function Infinity(arg1: LogicalType): Value; overload; static;

This item has no description.

Public class function Numeric(arg1: LogicalType; arg2: Int64): Value; overload; static;

This item has no description.

Public class function Numeric(arg1: LogicalType; arg2: hugeint_t): Value; overload; static;

This item has no description.

Public class function Numeric(arg1: LogicalType; arg2: uhugeint_t): Value; overload; static;

This item has no description.

Public class function BOOLEAN(arg1: Shortint): Value; overload; static;

This item has no description.

Public class function TINYINT(arg1: Shortint): Value; overload; static;

This item has no description.

Public class function SMALLINT(arg1: Smallint): Value; overload; static;

This item has no description.

Public class function INTEGER(arg1: Integer): Value; overload; static;

This item has no description.

Public class function BIGINT(arg1: Int64): Value; overload; static;

This item has no description.

Public class function UTINYINT(arg1: Byte): Value; overload; static;

This item has no description.

Public class function USMALLINT(arg1: Word): Value; overload; static;

This item has no description.

Public class function UINTEGER(arg1: Cardinal): Value; overload; static;

This item has no description.

Public class function UBIGINT(arg1: UInt64): Value; overload; static;

This item has no description.

Public class function HUGEINT(arg1: hugeint_t): Value; overload; static;

This item has no description.

Public class function UHUGEINT(arg1: uhugeint_t): Value; overload; static;

This item has no description.

Public class function UUID(arg1: str): Value; overload; static;

This item has no description.

Public class function UUID(arg1: hugeint_t): Value; overload; static;

This item has no description.

Public class function HASH(arg1: UInt64): Value; overload; static;

This item has no description.

Public class function POINTER(arg1: PUIntPtr): Value; overload; static;

This item has no description.

Public class function DATE(arg1: date_t): Value; overload; static;

This item has no description.

Public class function DATE(arg1: Integer; arg2: Integer; arg3: Integer): Value; overload; static;

This item has no description.

Public class function TIME(arg1: dtime_t): Value; overload; static;

This item has no description.

Public class function TIMETZ(arg1: dtime_tz_t): Value; overload; static;

This item has no description.

Public class function TIME(arg1: Integer; arg2: Integer; arg3: Integer; arg4: Integer): Value; overload; static;

This item has no description.

Public class function TIMESTAMP(arg1: date_t; arg2: dtime_t): Value; overload; static;

This item has no description.

Public class function TIMESTAMP(arg1: timestamp_t): Value; overload; static;

This item has no description.

Public class function TIMESTAMPNS(arg1: timestamp_t): Value; overload; static;

This item has no description.

Public class function TIMESTAMPMS(arg1: timestamp_t): Value; overload; static;

This item has no description.

Public class function TIMESTAMPSEC(arg1: timestamp_t): Value; overload; static;

This item has no description.

Public class function TIMESTAMPTZ(arg1: timestamp_t): Value; overload; static;

This item has no description.

Public class function TIMESTAMP(arg1: Integer; arg2: Integer; arg3: Integer; arg4: Integer; arg5: Integer; arg6: Integer; arg7: Integer): Value; overload; static;

This item has no description.

Public class function INTERVAL(arg1: Integer; arg2: Integer; arg3: Int64): Value; overload; static;

This item has no description.

Public class function INTERVAL(arg1: interval_t): Value; overload; static;

This item has no description.

Public class function ENUM(arg1: UInt64; arg2: LogicalType): Value; overload; static;

This item has no description.

Public class function DECIMAL(arg1: Smallint; arg2: Byte; arg3: Byte): Value; overload; static;

This item has no description.

Public class function DECIMAL(arg1: Integer; arg2: Byte; arg3: Byte): Value; overload; static;

This item has no description.

Public class function DECIMAL(arg1: Int64; arg2: Byte; arg3: Byte): Value; overload; static;

This item has no description.

Public class function DECIMAL(arg1: hugeint_t; arg2: Byte; arg3: Byte): Value; overload; static;

This item has no description.

Public class function FLOAT(arg1: Single): Value; overload; static;

This item has no description.

Public class function DOUBLE(arg1: Double): Value; overload; static;

This item has no description.

Public class function STRUCT(arg1: duckdb_vector_std_pair_std_string_duckdb_Value__true): Value; overload; static;

This item has no description.

Public class function STRUCT(arg1: LogicalType; arg2: vector_Value): Value; overload; static;

This item has no description.

Public class function LIST(arg1: vector_Value): Value; overload; static;

This item has no description.

Public class function LIST(arg1: LogicalType; arg2: vector_Value): Value; overload; static;

This item has no description.

Public class function EMPTYLIST(arg1: LogicalType): Value; overload; static;

This item has no description.

Public class function ARRAY(arg1: vector_Value): Value; overload; static;

This item has no description.

Public class function ARRAY(arg1: LogicalType; arg2: vector_Value): Value; overload; static;

This item has no description.

Public class function EMPTYARRAY(arg1: LogicalType; arg2: Cardinal): Value; overload; static;

This item has no description.

Public class function MAP(arg1: LogicalType; arg2: vector_Value): Value; overload; static;

This item has no description.

Public class function MAP(arg1: LogicalType; arg2: LogicalType; arg3: vector_Value; arg4: vector_Value): Value; overload; static;

This item has no description.

Public class function UNION(arg1: duckdb_vector_std_pair_std_string_duckdb_LogicalType__true; arg2: Byte; arg3: Value): Value; overload; static;

This item has no description.

Public class function BLOB(arg1: PByte; arg2: UInt64): Value; overload; static;

This item has no description.

Public class function BLOB_RAW(arg1: str): Value; overload; static;

This item has no description.

Public class function BLOB(arg1: str): Value; overload; static;

This item has no description.

Public class function BIT(arg1: PByte; arg2: UInt64): Value; overload; static;

This item has no description.

Public class function BIT(arg1: str): Value; overload; static;

This item has no description.

Public class function AGGREGATE_STATE(arg1: LogicalType; arg2: PByte; arg3: UInt64): Value; overload; static;

This item has no description.

Public function Copy(): Value; overload;

This item has no description.

Public function Hash(): UInt64; overload;

This item has no description.

Public function ToString(): str; overload;

This item has no description.

Public function ToSQLString(): str; overload;

This item has no description.

Public function GetPointer(): PUIntPtr; overload;

This item has no description.

Public function CastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType; arg5: Boolean): Value; overload;

This item has no description.

Public function CastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType): Value; overload;

This item has no description.

Public function CastAs(arg2: ClientContext; arg3: LogicalType; arg4: Boolean): Value; overload;

This item has no description.

Public function CastAs(arg2: ClientContext; arg3: LogicalType): Value; overload;

This item has no description.

Public function DefaultCastAs(arg2: LogicalType; arg3: Boolean): Value; overload;

This item has no description.

Public function DefaultCastAs(arg2: LogicalType): Value; overload;

This item has no description.

Public function TryCastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType; arg5: Value; arg6: str; arg7: Boolean): Boolean; overload;

This item has no description.

Public function TryCastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType; arg5: Value; arg6: str): Boolean; overload;

This item has no description.

Public function TryCastAs(arg2: ClientContext; arg3: LogicalType; arg4: Value; arg5: str; arg6: Boolean): Boolean; overload;

This item has no description.

Public function TryCastAs(arg2: ClientContext; arg3: LogicalType; arg4: Value; arg5: str): Boolean; overload;

This item has no description.

Public function DefaultTryCastAs(arg2: LogicalType; arg3: Value; arg4: str; arg5: Boolean): Boolean; overload;

This item has no description.

Public function DefaultTryCastAs(arg2: LogicalType; arg3: Value; arg4: str): Boolean; overload;

This item has no description.

Public function TryCastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType; arg5: Boolean): Boolean; overload;

This item has no description.

Public function TryCastAs(arg2: CastFunctionSet; arg3: GetCastFunctionInput; arg4: LogicalType): Boolean; overload;

This item has no description.

Public function TryCastAs(arg2: ClientContext; arg3: LogicalType; arg4: Boolean): Boolean; overload;

This item has no description.

Public function TryCastAs(arg2: ClientContext; arg3: LogicalType): Boolean; overload;

This item has no description.

Public function DefaultTryCastAs(arg2: LogicalType; arg3: Boolean): Boolean; overload;

This item has no description.

Public function DefaultTryCastAs(arg2: LogicalType): Boolean; overload;

This item has no description.

Public procedure Reinterpret(arg2: LogicalType); overload;

This item has no description.

Public procedure Serialize(arg2: Serializer); overload;

This item has no description.

Public class function Deserialize(arg1: Deserializer): Value; overload; static;

This item has no description.

Public class function FloatIsFinite(arg1: Single): Boolean; overload; static;

This item has no description.

Public class function DoubleIsFinite(arg1: Double): Boolean; overload; static;

This item has no description.

Public class function StringIsValid(arg1: PUTF8Char; arg2: UInt64): Boolean; overload; static;

This item has no description.

Public class function StringIsValid(arg1: str): Boolean; overload; static;

This item has no description.

Public class function ValuesAreEqual(arg1: CastFunctionSet; arg2: GetCastFunctionInput; arg3: Value; arg4: Value): Boolean; overload; static;

This item has no description.

Public class function ValuesAreEqual(arg1: ClientContext; arg2: Value; arg3: Value): Boolean; overload; static;

This item has no description.

Public class function DefaultValuesAreEqual(arg1: Value; arg2: Value): Boolean; overload; static;

This item has no description.

Public class function NotDistinctFrom(arg1: Value; arg2: Value): Boolean; overload; static;

This item has no description.

Public procedure Print(); overload;

This item has no description.

Error Message