Results of 1 - 10 of about 77 for double (0.005 sec.)
- Spatial Functions 14559
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...│ ├───────────────────────┤ │ 9.1.1 │ └───────────────────────┘ ST_Affine Signatures GEOMETRY ST_Affine (geom GEOMETRY, a DOUBLE, b DOUBLE, c DOUBLE, d DOUBLE, e DOUBLE, f DOUBLE, g DOUBLE, h DOUBLE, i DOUBLE, xoff DOUBLE, yoff DOUBLE, zoff DOUBLE) GE...OMETRY ST_Affine (geom GEOMETRY, a DOUBLE, b DOUBLE, d DOUBLE, e DOUBLE, xoff DOUBLE, yoff DOUBLE) Description Applies an affine transformation to a geometry. For t...0, 0, -- a, b, c 0, 2, 0, -- d, e, f 0, 0, 1, -- g, h, i 0, 0, 0); -- xoff, yoff, zoff ---- POINT (2 2) ST_Area Signatures DOUBLE ST_Area (geom GEOMETRY) DOUBLE ST_Area (polygon POLYGON_2D) DOUBLE ST_Area (linestring LINESTRING_2D) DOUBLE ST_Area (poin... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Metrics 11520
- DuckDB provides a set of metrics that can be used to monitor the performance and health of the database. Metrics are named ⟨group⟩.⟨metric⟩ , e.g., query.total_time or operator.timing . The set of collected metrics is controlled with the tr
...r planner physical_planner query Metrics Metrics measured over the entire query. Name Type Unit Description query.cpu_time double seconds CPU time spent on the query query.sql string The SQL string of the query query.total_intermediate_rows uint64 rows...ups available to scan query.total_rows_scanned uint64 rows Cumulative number of rows scanned by the query query.total_time double seconds Time spent executing the entire query system Metrics Metrics on system resources, such as memory and threads, used...while running the query. Name Type Unit Description system.blocked_thread_time double seconds Time spent waiting for a thread to become available system.peak_buffer_memory uint64 bytes Peak memory usage of th... - https://man.mtool.work/duckdb/2.0/dev/metrics.html
- Types 11175
- 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
...INT = 6, DUCKDB_TYPE_USMALLINT = 7, DUCKDB_TYPE_UINTEGER = 8, DUCKDB_TYPE_UBIGINT = 9, DUCKDB_TYPE_FLOAT = 10, DUCKDB_TYPE_DOUBLE = 11, DUCKDB_TYPE_TIMESTAMP = 12, DUCKDB_TYPE_DATE = 13, DUCKDB_TYPE_TIME = 14, DUCKDB_TYPE_INTERVAL = 15, DUCKDB_TYPE_HUG...ckdb_value The duckdb_value functions will auto-cast values as required. For example, it is no problem to use duckdb_value_double on a column of type duckdb_value_int32 . The value will be auto-cast and returned as a double. Note that in certain cases...te_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 ); Decimal Helpers d... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Complete API 10981
- 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
...db_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 , idx_t col , idx_t row ); duckdb_date duckdb_value_date ( duckdb_result * re...te_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 ); Unsigned Hugeint...Helpers double duckdb_uhugeint_to_double ( duckdb_uhugeint val ); duckdb_uhugeint duckdb_double_to_uhugeint ( double val ); Decimal Helpe... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Excel Extension 8481
- The excel extension provides functions to format numbers per Excel's formatting rules by wrapping the i18npool library and to read/write Excel ( .xlsx ) files. However, please note that .xls files are not supported. Installing and Loading T
...is is false by default, otherwise true . empty_as_varchar BOOLEAN false Whether to treat empty cells as VARCHAR instead of DOUBLE when trying to automatically infer column types. SELECT * FROM read_xlsx('test.xlsx', header = true); a b 1.0 2.0 3.0 4.0...s of the columns in the target table will be used to coerce the types of the cells in the Excel file. CREATE TABLE test (a DOUBLE, b DOUBLE); COPY test FROM 'test.xlsx' WITH (FORMAT xlsx, HEADER); SELECT * FROM test; Type and Range Inference Because Ex..."infer" and decide the types of the columns when importing an Excel sheet. While almost all columns are inferred as either DOUBLE or VARCHAR , there are some caveats: TIMESTAMP , TIME , DATE and BOOLEAN types are inferred when possible based on the for... - https://man.mtool.work/duckdb/2.0/core_extensions/excel.html
- Typecasting 8343
- 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
...ions, and is generally only possible when the cast cannot fail. For example, an implicit cast can be added from INTEGER to DOUBLE – but not from DOUBLE to INTEGER . Consider the function sin(DOUBLE) . This function takes as input argument a column of t...ype DOUBLE , however, it can be called with an integer as well: sin(1) . The integer is converted into a double before being passed t...less, so they are also safe to reverse, with the notable exception of casts from wide integer or DECIMAL types to FLOAT or DOUBLE , which can lose precision. Explicit-only casts may lose information or fail for particular values. In the matrix below, r... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Values 8288
- 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
...ckdb_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 ); duckdb_value duckdb_create_time ( duckdb_time inp...( 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_value val ); duckdb_time duckdb_get_time ( du...arameters input : The float value Return Value The value. This must be destroyed with duckdb_destroy_value . duckdb_create_double Creates a value from a double Syntax duckdb_value duckdb_create_double ( double input ); Parameters input : The double val... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Literal Types 8191
- DuckDB has special literal types for representing NULL , integer and string literals in queries. These have their own binding and conversion rules. Prior to DuckDB version 0.10.0, integer and string literals behaved identically to the INTEG
...iterals String literals are delimited using single quotes ( ' , apostrophe) and result in STRING_LITERAL values. Note that double quotes ( " ) cannot be used as string delimiter character: instead, double quotes are used to delimit quoted identifiers ....ge return 13 \t tab 9 Dollar-Quoted String Literals DuckDB supports dollar-quoted string literals, which are surrounded by double-dollar symbols ( $$ ): SELECT $$Hello world$$ AS msg; ┌──────────────┐ │ msg │ │ varchar │ ├──────────────┤ │ Hello\nworld...─────────┘ SELECT $$The price is $9.95$$ AS msg; msg The price is $9.95 Even more, you can insert alphanumeric tags in the double-dollar symbols to allow for the use of regular double-dollar symbols within the string literal: SELECT $tag$ this string c... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Functions 7749
- Function Syntax Function Chaining via the Dot Operator DuckDB supports the dot syntax for function chaining. This allows the function call fn(arg1, arg2, arg3, ...) to be rewritten as arg1.fn(arg2, arg3, ...) . For example, take the followi
...e; function_name function_type return_type parameters parameter_types description bar scalar VARCHAR [x, min, max, width] [DOUBLE, DOUBLE, DOUBLE, DOUBLE] Draws a band whose width is proportional to (x - min) and equal to width characters when x = max.... - https://man.mtool.work/duckdb/2.0/sql/functions/overview.html
- Geometry Data Type 7611
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...ns. When a row group qualifies, DuckDB splits the geometry segment within the row group into primitive STRUCT , LIST , and DOUBLE segments that can be compressed independently using lightweight algorithms - far more efficiently than storing variable-si...ze binary blobs. The shredded layout depends on the geometry type: POINT - STRUCT(X DOUBLE, Y DOUBLE) (and/or Z, M) LINESTRING - STRUCT(X DOUBLE, Y DOUBLE)[] POLYGON - STRUCT(X DOUBLE, Y DOUBLE)[][] MULTIPOINT , M...───┤ │ GEOMETRY │ │ VALIDITY │ └──────────────┘ -- While the geometry column in `shredded_db` is decomposed into primitive DOUBLE segments, -- which can be compressed much more efficiently! SELECT DISTINCT(segment_type) FROM pragma_storage_info('shredd... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
DuckDB 2.0 Documentation / man.mtool.work