Results of 1 - 10 of about 34 for Float (0.005 sec.)
- Array Functions – DuckDB 15562
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ay1, array2) . array_value(arg1, ...) Description Create an ARRAY containing the argument values. Example array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT) Result [1.0, 2.0, 3.0] array_cross_product(array1, array2) Description Compute the cross product...of two arrays of size 3. The array elements can not be NULL . Example array_cross_product(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT)) Result [-1.0, 2.0, -1.0] array_cosine_similarit...ays can have any size as long as the size is the same for both arguments. Example array_cosine_similarity(array_value(1.0::FLOAT, 2.0::FLOAT, 3.0::FLOAT), array_value(2.0::FLOAT, 3.0::FLOAT, 4.0::FLOAT)) Result 0.9925833 array_cosine_distance(array1,... - https://man.mtool.work/duckdb/1.3/sql/functions/array.html
- Vector Similarity Search Extension – DuckDB 9985
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...REATE INDEX statement with the USING HNSW clause. For example: INSTALL vss ; LOAD vss ; CREATE TABLE my_vector_table ( vec FLOAT [ 3 ]); INSERT INTO my_vector_table SELECT array_value ( a , b , c ) FROM range ( 1 , 10 ) ra ( a ), range ( 1 , 10 ) rb (...or, followed by a LIMIT clause. For example: SELECT * FROM my_vector_table ORDER BY array_distance ( vec , [ 1 , 2 , 3 ]:: FLOAT [ 3 ]) LIMIT 3 ; Additionally, the overloaded min_by(col, arg, n) can also be accelerated with the HNSW index if the arg a...op 3 rows with the closest vectors to [1, 2, 3] : SELECT min_by ( my_vector_table , array_distance ( vec , [ 1 , 2 , 3 ]:: FLOAT [ 3 ]), 3 ORDER BY vec ) AS result FROM my_vector_table ; [{'vec': [1.0, 2.0, 3.0]}, {'vec': [2.0, 2.0, 3.0]}, {'vec': [1.... - https://man.mtool.work/duckdb/1.3/core_extensions/vss.html
- Values – DuckDB 9634
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...te_varint ( duckdb_varint input ); duckdb_value duckdb_create_decimal ( duckdb_decimal input ); duckdb_value duckdb_create_float ( float input ); duckdb_value duckdb_create_double ( double input ); duckdb_value duckdb_create_date ( duckdb_date input )...value val ); duckdb_varint duckdb_get_varint ( duckdb_value val ); duckdb_decimal duckdb_get_decimal ( duckdb_value val ); float duckdb_get_float ( duckdb_value val ); double duckdb_get_double ( duckdb_value val ); duckdb_date duckdb_get_date ( duckdb...input : The duckdb_decimal value Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_float Creates a value from a float Syntax duckdb_value duckdb_create_float ( float input ); Parameters input : The float value R... - https://man.mtool.work/duckdb/1.3/clients/c/value.html
- Array Type – DuckDB 9570
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...native functions are also supported. See the ARRAY functions . Examples Create sample data: CREATE TABLE x ( i INTEGER , v FLOAT [ 3 ]); CREATE TABLE y ( i INTEGER , v FLOAT [ 3 ]); INSERT INTO x VALUES ( 1 , array_value ( 1.0 :: FLOAT , 2.0 :: FLOAT..., 3.0 :: FLOAT )); INSERT INTO y VALUES ( 1 , array_value ( 2.0 :: FLOAT , 3.0 :: FLOAT , 4.0 :: FLOAT )); Compute cross product: SELECT... - https://man.mtool.work/duckdb/1.3/sql/data_types/array.html
- Numeric Types – DuckDB 9282
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...fixed-point decimals does not typically produce numbers with finite decimal expansion. Therefore, DuckDB uses approximate floating-point arithmetic for all divisions that involve fixed-point decimals and accordingly returns floating-point data types....is therefore recommended to stick with a WIDTH of 18 or below, unless there is a good reason for why this is insufficient. Floating-Point Types The data types FLOAT and DOUBLE precision are variable-precision numeric types. In practice, these types ar...e usually implementations of IEEE Standard 754 for Binary Floating-Point Arithmetic (single and double precision, respectively), to the extent that the underlying processor, operating sy... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Complete API – DuckDB 9155
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...esult * result , idx_t col , idx_t row ); uint64_t duckdb_value_uint64 ( duckdb_result * result , idx_t col , idx_t row ); float duckdb_value_float ( duckdb_result * result , idx_t col , idx_t row ); double duckdb_value_double ( duckdb_result * result...db_bind_uint64 ( duckdb_prepared_statement prepared_statement , idx_t param_idx , uint64_t val ); duckdb_state duckdb_bind_float ( duckdb_prepared_statement prepared_statement , idx_t param_idx , float val ); duckdb_state duckdb_bind_double ( duckdb_p...te_varint ( duckdb_varint input ); duckdb_value duckdb_create_decimal ( duckdb_decimal input ); duckdb_value duckdb_create_float ( float input ); duckdb_value duckdb_create_double ( double input ); duckdb_value duckdb_create_date ( duckdb_date input )... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- PHP Client – DuckDB 8803
- This page is for DuckDB 1.3, which is outdated. Switch to the current documentation . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Ove
...e ( 'duck.db' ); // or DuckDB::create() for in-memory database $duckDB -> query ( 'CREATE TABLE test (i INTEGER, b BOOL, f FLOAT);' ); $duckDB -> query ( 'INSERT INTO test VALUES (3, true, 1.1), (5, true, 1.2), (3, false, 1.1), (3, null, 1.2);' ); $du...our query. Prepared Statements $duckDB = DuckDB :: create (); $duckDB -> query ( 'CREATE TABLE test (i INTEGER, b BOOL, f FLOAT);' ); $duckDB -> query ( 'INSERT INTO test VALUES (3, true, 1.1), (5, true, 1.2), (3, false, 1.1), (3, null, 1.2);' ); $bo...MALLINT int DUCKDB_TYPE_UINTEGER UINTEGER int DUCKDB_TYPE_UBIGINT UBIGINT Saturio\DuckDB\Type\Math\LongInteger DUCKDB_TYPE_FLOAT FLOAT float DUCKDB_TYPE_DOUBLE DOUBLE float DUCKDB_TYPE_TIMESTAMP TIMESTAMP Saturio\DuckDB\Type\Timestamp DUCKDB_TYPE_DATE... - https://man.mtool.work/duckdb/1.3/clients/php.html
- PostgreSQL Compatibility – DuckDB 8803
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...SQL dialect closely follows the conventions of the PostgreSQL dialect. The few exceptions to this are listed on this page. Floating-Point Arithmetic DuckDB and PostgreSQL handle floating-point arithmetic differently for division by zero. DuckDB confor...ms to the IEEE Standard for Floating-Point Arithmetic (IEEE 754) for both division by zero and operations involving infinity values. PostgreSQL returns an e...n the following SQL queries: SELECT 1.0 / 0.0 AS x ; SELECT 0.0 / 0.0 AS x ; SELECT -1.0 / 0.0 AS x ; SELECT 'Infinity' :: FLOAT / 'Infinity' :: FLOAT AS x ; SELECT 1.0 / 'Infinity' :: FLOAT AS x ; SELECT 'Infinity' :: FLOAT - 'Infinity' :: FLOAT AS x... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Types API – DuckDB 8212
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...ows the mapping of Python Built-in types to DuckDB type. Built-in types DuckDB type bool BOOLEAN bytearray BLOB bytes BLOB float DOUBLE int BIGINT str VARCHAR Numpy DTypes The table below shows the mapping of Numpy DType to DuckDB type. Type DuckDB ty...pe bool BOOLEAN float32 FLOAT float64 DOUBLE int16 SMALLINT int32 INTEGER int64 BIGINT int8 TINYINT uint16 USMALLINT uint32 UINTEGER uint64 UBIG...r the built-in types, you can use the constants defined in duckdb.typing : DuckDB type BIGINT BIT BLOB BOOLEAN DATE DOUBLE FLOAT HUGEINT INTEGER INTERVAL SMALLINT SQLNULL TIME_TZ TIME TIMESTAMP_MS TIMESTAMP_NS TIMESTAMP_S TIMESTAMP_TZ TIMESTAMP TINYIN... - https://man.mtool.work/duckdb/1.3/clients/python/types.html
- Numeric Functions – DuckDB 8212
- This page is for DuckDB 1.3, which is outdated. Switch to the current version . Search Shortcut cmd + k | ctrl + k Installation Documentation Getting Started Connect Overview Concurrency Data Import Overview Data Sources CSV Files Overview
...r numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5 // 2 2 % Modulo (remainder) 5 % 4 1 ** Exponent 3 ** 4 81 ^ Exponent (alias for ** ) 3 ^...d Modulo Operators There are two division operators: / and // . They are equivalent when at least one of the operands is a FLOAT or a DOUBLE . When both operands are integers, / performs floating points division ( 5 / 2 = 2.5 ) while // performs integ...the greatest common divisor of x and y . greatest(x1, x2, ...) Selects the largest value. isfinite(x) Returns true if the floating point value is finite, false otherwise. isinf(x) Returns true if the floating point value is infinite, false otherwise.... - https://man.mtool.work/duckdb/1.3/sql/functions/numeric.html
DuckDB 1.3 Documentation / man.mtool.work