Results of 1 - 10 of about 18 for floating (0.002 sec.)
- Numeric Types 14704
- 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
...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. In...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 are u...sually implementations of IEEE Standard 754 for Binary Floating-Point Arithmetic (single and double precision, respectively), to the extent that the underlying processor, operating syste... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Numeric Functions 10638
- Numeric Operators The table below shows the available mathematical operators for 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
...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 integer division ( 5 // 2 = 2 ). Integer division ( // ), modulo ( % ),...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. is...nan(x) Returns true if the floating point value is not a number, false otherwise. lcm(x, y) Computes the least common multiple of x and y . least_common_multi... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Non-Deterministic Behavior 9814
- Several operators in DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi-
...rms : SELECT array_distinct(['A', 'A', 'B', NULL, NULL]) AS arr; For this query, both [A, B] and [B, A] are valid results. Floating-Point Aggregate Operations with Multi-Threading Floating-point inaccuracies may produce different results when run in mult...ll values of s . However, when executed on multiple threads, the query may return small numbers ( 0 <= z < 10e-16 ) due to floating-point inaccuracies. Working Around Non-Determinism For the majority of use cases, non-determinism is not causing any issue... - https://man.mtool.work/duckdb/2.0/operations_manual/non-deterministic_behavior.h...
- PostgreSQL Compatibility 8785
- DuckDB's 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 conforms to the IEEE Standard for Floating-Point Arithmetic (IEEE 754) for both division by zero and operations involving infinity values. PostgreSQL returns an erro... - https://man.mtool.work/duckdb/2.0/sql/dialect/postgresql_compatibility.html
- Aggregate Functions 8699
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...ng, returning a DECIMAL with the same width and scale as the input. favg(arg) Calculates the average using a more accurate floating point summation (Kahan Sum). This function is affected by ordering . first(arg) Returns the first value (null or non-null)...from arg . This function is affected by ordering . fsum(arg) Calculates the sum using a more accurate floating point summation (Kahan Sum). This function is affected by ordering . geometric_mean(arg) Calculates the geometric mean of...cted by ordering . sum(arg) Calculates the sum of all non-null values in arg / counts true values when arg is boolean. The floating-point versions of this function are affected by ordering . weighted_avg(arg, weight) Calculates the weighted average of al... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
- Pragmas 8613
- The PRAGMA statement is a SQL extension adopted by DuckDB from SQLite. PRAGMA statements can be issued in a similar manner to regular SQL statements. PRAGMA commands may alter the internal state of the database engine, and can influence the
...l", "candidates":"temp.information_schema.tables", "position":"14", "type":"Table", "error_subtype":"MISSING_ENTRY" } IEEE Floating-Point Operation Semantics DuckDB follows IEEE floating-point operation semantics. If you would like to turn this off, run:...SET ieee_floating_point_ops = false; In this case, floating point division by zero (e.g., 1.0 / 0.0 , 0.0 / 0.0 and -1.0 / 0.0 ) throws an e... - https://man.mtool.work/duckdb/2.0/configuration/pragmas.html
- Data Types 8510
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...sion number with the given width (precision) and scale, defaults to prec = 18 and scale = 3 DOUBLE FLOAT8 Double precision floating-point number (8 bytes) FLOAT FLOAT4 , REAL Single precision floating-point number (4 bytes) GEOMETRY Geospatial entity, se... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- Interval Functions 8424
- This section describes functions and operators for examining and manipulating INTERVAL values. Interval Operators The table below shows the available mathematical operators for INTERVAL types. Operator Description Example Result + Addition
...e_part . extract(part FROM interval) Alias of date_part . epoch(interval) Get total number of seconds, as double precision floating point number, in interval. normalized_interval(interval) Normalizes an interval so that units that overflow their range ar...OM INTERVAL '14 months') | | Result | 2 | epoch(interval) | Description | Get total number of seconds, as double precision floating point number, in interval. | | Example | epoch(INTERVAL 5 HOUR) | | Result | 18000.0 | normalized_interval(interval) | Des... - https://man.mtool.work/duckdb/2.0/sql/functions/interval.html
- Configuration 7961
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...P requests BOOLEAN true httpfs_enable_credential_refresh Enable credential refresh for HTTPFS S3 secrets BOOLEAN true ieee_floating_point_ops Use IEEE 754 behavior for supported floating point operations, returning NAN/INF instead of errors/NULL. BOOLEAN...l reaching the block size. UBIGINT 2048 integer_division Whether or not the / operator defaults to integer division, or to floating point division. BOOLEAN false json_geometry_format How GEOMETRY values are written to JSON : 'wkt' for Well-Known Text, or... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Querying Parquet Metadata 7772
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...for the following types: Integer types: TINYINT , UTINYINT , SMALLINT , USMALLINT , INTEGER , UINTEGER , BIGINT , UBIGINT Floating point types: FLOAT , DOUBLE VARCHAR BLOB The parquet_bloom_probe(filename, column_name, value) function shows which row gr... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
DuckDB 2.0 Documentation / man.mtool.work