Results of 1 - 10 of about 21 for hugeint (0.005 sec.)
- Complete API 13141
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...* result , idx_t col , idx_t row ); int64_t duckdb_value_int64 ( duckdb_result * result , idx_t col , idx_t row ); duckdb_hugeint duckdb_value_hugeint ( duckdb_result * result , idx_t col , idx_t row ); duckdb_uhugeint duckdb_value_uhugeint ( duckdb_re...l duckdb_is_finite_timestamp_ms ( duckdb_timestamp_ms ts ); bool duckdb_is_finite_timestamp_ns ( duckdb_timestamp_ns ts ); Hugeint Helpers double duckdb_hugeint_to_double ( duckdb_hugeint val ); duckdb_hugeint duckdb_double_to_hugeint ( double val ); Un...signed Hugeint Helpers double duckdb_uhugeint_to_double ( duckdb_uhugeint val ); duckdb_uhugeint duckdb_double_to_uhugeint ( double val )... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Types 12177
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...BLE = 11, DUCKDB_TYPE_TIMESTAMP = 12, DUCKDB_TYPE_DATE = 13, DUCKDB_TYPE_TIME = 14, DUCKDB_TYPE_INTERVAL = 15, DUCKDB_TYPE_HUGEINT = 16, DUCKDB_TYPE_UHUGEINT = 32, DUCKDB_TYPE_VARCHAR = 17, DUCKDB_TYPE_BLOB = 18, DUCKDB_TYPE_DECIMAL = 19, DUCKDB_TYPE_TI...l duckdb_is_finite_timestamp_ms ( duckdb_timestamp_ms ts ); bool duckdb_is_finite_timestamp_ns ( duckdb_timestamp_ns ts ); Hugeint Helpers double duckdb_hugeint_to_double ( duckdb_hugeint val ); duckdb_hugeint duckdb_double_to_hugeint ( double val ); De...ned from a DUCKDB_TYPE_TIMESTAMP_NS column. Return Value True if the timestamp is finite, false if it is ±infinity. duckdb_hugeint_to_double Converts a duckdb_hugeint object (as obtained from a DUCKDB_TYPE_HUGEINT column) into a double. Syntax double du... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Values 11585
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
...alue duckdb_create_uint64 ( uint64_t input ); duckdb_value duckdb_create_int64 ( int64_t val ); duckdb_value duckdb_create_hugeint ( duckdb_hugeint input ); duckdb_value duckdb_create_uhugeint ( duckdb_uhugeint input ); duckdb_value duckdb_create_bignum..._t * data , idx_t length ); duckdb_value duckdb_create_bit ( duckdb_bit input ); duckdb_value duckdb_create_uuid ( duckdb_uhugeint input ); bool duckdb_get_bool ( duckdb_value val ); int8_t duckdb_get_int8 ( duckdb_value val ); uint8_t duckdb_get_uint8...duckdb_value val ); int64_t duckdb_get_int64 ( duckdb_value val ); uint64_t duckdb_get_uint64 ( duckdb_value val ); duckdb_hugeint duckdb_get_hugeint ( duckdb_value val ); duckdb_uhugeint duckdb_get_uhugeint ( duckdb_value val ); duckdb_bignum duckdb_ge... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Appender 9268
- Appenders are the most efficient way of loading data into DuckDB from within the C interface, and are recommended for fast data loading. The appender is much faster than using prepared statements or individual INSERT INTO statements. Append
...int32_t value ); duckdb_state duckdb_append_int64 ( duckdb_appender appender , int64_t value ); duckdb_state duckdb_append_hugeint ( duckdb_appender appender , duckdb_hugeint value ); duckdb_state duckdb_append_uint8 ( duckdb_appender appender , uint8_t...32_t value ); duckdb_state duckdb_append_uint64 ( duckdb_appender appender , uint64_t value ); duckdb_state duckdb_append_uhugeint ( duckdb_appender appender , duckdb_uhugeint value ); duckdb_state duckdb_append_float ( duckdb_appender appender , float...value to the appender. Syntax duckdb_state duckdb_append_int64 ( duckdb_appender appender , int64_t value ); duckdb_append_hugeint Append a duckdb_hugeint value to the appender. Syntax duckdb_state duckdb_append_hugeint ( duckdb_appender appender , duck... - https://man.mtool.work/duckdb/2.0/clients/c/appender.html
- Numeric Types 9268
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...in an error. The types UTINYINT , USMALLINT , UINTEGER , UBIGINT and UHUGEINT store whole unsigned numbers. Attempts to store negative numbers or values outside of the allowed range will result in an...SHORT - 2^15 2^15 - 1 2 INTEGER INT4 , INT32 , INT , SIGNED - 2^31 2^31 - 1 4 BIGINT INT8 , INT64 , LONG - 2^63 2^63 - 1 8 HUGEINT INT128 - 2^127 2^127 - 1 16 UTINYINT UINT8 0 2^8 - 1 1 USMALLINT UINT16 0 2^16 - 1 2 UINTEGER UINT32 0 2^32 - 1 4 UBIGINT...UINT64 0 2^64 - 1 8 UHUGEINT UINT128 0 2^128 - 1 16 INT8 is a 64-bit integer, and is not the signed equivalent of UINT8 , an unsigned, 8-bit integer. T... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Blob Functions 8203
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...encoding. md5(blob) Returns the MD5 hash of the blob as a VARCHAR . md5_number(blob) Returns the MD5 hash of the blob as a HUGEINT . octet_length(blob) Number of bytes in blob . read_blob(source) Returns the content from source (a filename, a list of fi...OB) | | Result | 58cea1f6b2b06520613e09af90dc1c47 | md5_number(blob) | Description | Returns the MD5 hash of the blob as a HUGEINT . | | Example | md5_number('\xAA\xBB'::BLOB) | | Result | 94525045605907259200829535064523132504 | octet_length(blob) | De... - https://man.mtool.work/duckdb/2.0/sql/functions/blob.html
- Vectors 8118
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...uckdb_timestamp DUCKDB_TYPE_DATE duckdb_date DUCKDB_TYPE_TIME duckdb_time DUCKDB_TYPE_INTERVAL duckdb_interval DUCKDB_TYPE_HUGEINT duckdb_hugeint DUCKDB_TYPE_UHUGEINT duckdb_uhugeint DUCKDB_TYPE_VARCHAR duckdb_string_t DUCKDB_TYPE_BLOB duckdb_string_t D...ckdb_timestamp DUCKDB_TYPE_TIMESTAMP_MS duckdb_timestamp DUCKDB_TYPE_TIMESTAMP_NS duckdb_timestamp DUCKDB_TYPE_UUID duckdb_hugeint DUCKDB_TYPE_TIME_TZ duckdb_time_tz DUCKDB_TYPE_TIMESTAMP_TZ duckdb_timestamp NULL Values Any value in a vector can be NULL...f the decimal type, as shown in the following table: Width NativeType <= 4 int16_t <= 9 int32_t <= 18 int64_t <= 38 duckdb_hugeint The duckdb_decimal_internal_type can be used to obtain the internal type of the decimal. Decimals are stored as integer va... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- Conversion between DuckDB and Python 8118
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...ot a one-to-one conversion possible for ints. An int becomes the first of these types that fits it: INTEGER BIGINT UBIGINT HUGEINT UHUGEINT So 2**31 is a BIGINT , 2**63 a UBIGINT , 2**64 and -(2**63) - 1 are HUGEINT and 2**127 is a UHUGEINT . An integer...rint(con.execute("SELECT typeof(?), typeof(?), typeof(?)", [5, 2**64, duckdb.Value(5, TINYINT)]).fetchall()) [('INTEGER', 'HUGEINT', 'TINYINT')] float A float is always a DOUBLE . datetime.datetime For datetime we will check pandas.isnull if it's availa... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- PHP Client 8016
- The DuckDB PHP client is a tertiary client and is maintained by a third-party. Client API for PHP, focused on performance. The DuckDB PHP client uses the official C API internally through FFI , achieving good benchmark results. This library
...Date DUCKDB_TYPE_TIME TIME Saturio\DuckDB\Type\Time DUCKDB_TYPE_INTERVAL INTERVAL Saturio\DuckDB\Type\Interval DUCKDB_TYPE_HUGEINT HUGEINT Saturio\DuckDB\Type\Math\LongInteger DUCKDB_TYPE_UHUGEINT UHUGEINT Saturio\DuckDB\Type\Math\LongInteger DUCKDB_TYP... - https://man.mtool.work/duckdb/2.0/clients/tertiary_clients/php.html
- Typecasting 7915
- Typecasting is an operation that converts a value in one particular data type to the closest corresponding value in another data type. Like other SQL engines, DuckDB supports both implicit and explicit typecasting. Explicit Casting Explicit
...unparseable input). Column abbreviations: BOOL (BOOLEAN), I8 (TINYINT), I16 (SMALLINT), I32 (INTEGER), I64 (BIGINT), I128 (HUGEINT), U8 (UTINYINT), U16 (USMALLINT), U32 (UINTEGER), U64 (UBIGINT), U128 (UHUGEINT), F32 (FLOAT), F64 (DOUBLE), DEC (DECIMAL(...E SMALLINT E E I I I I E E E E E I I I E E INTEGER E E E I I I E E E E E I I I E E BIGINT E E E E I I E E E E E I I I E E HUGEINT E E E E E I E E E E E I I I E E UTINYINT E E I I I I I I I I I I I I E E USMALLINT E E E I I I E I I I I I I I E E UINTEGE...R E E E E I I E E I I I I I I E E UBIGINT E E E E E I E E E I I I I I E E UHUGEINT E E E E E E E E E E I I I I E E FLOAT E E E E E E E E E E E I I E E E DOUBLE E E E E E E E E E E E E I E E E DECIMAL(18, 3... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
DuckDB 2.0 Documentation / man.mtool.work