Results of 1 - 10 of about 60 for double (0.008 sec.)
- Spatial Functions – DuckDB 15123
- 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
...├───────────────────────┤ │ 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 ) GEOMETRY ST_Affine ( geom GEOMETRY , a DOUBLE , b DOUBLE , d DOUBLE , e DOUBLE , xoff DOUBLE , yoff DOUBLE ) Description...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... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
- Complete API – DuckDB 11837
- 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
...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/1.3/clients/c/api.html
- Types – DuckDB 11779
- 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
...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_TYP...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/1.3/clients/c/types.html
- Values – DuckDB 8856
- 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
...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/1.3/clients/c/value.html
- Literal Types – DuckDB 8594
- 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
...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\nwo...─────┘ 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... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Excel Extension – DuckDB 8376
- 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
...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...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 Beca..."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/1.3/core_extensions/excel.html
- JSON Processing Functions – DuckDB 7954
- 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
...arameters are of JSON type, but json_needle can also be a numeric value or a string, however the string must be wrapped in double quotes. json_keys(json[, path]) Returns the keys of json as a LIST of VARCHAR , if json is a JSON object. If path is speci...es in an array). json_type(json[, path]) Return the type of the supplied json , which is one of ARRAY , BIGINT , BOOLEAN , DOUBLE , OBJECT , UBIGINT , VARCHAR , and NULL . If path is specified, return the type of the element at the given path . If path...lists: SELECT json_extract ( '{"duck": [1, 2, 3]}' , '$.duck[#-1]' ); 3 JSONPath also allows escaping syntax tokens, using double quotes: SELECT json_extract ( '{"duck.goose": [1, 2, 3]}' , '$."duck.goose"[1]' ); 2 Examples using the anatidae biologica... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Typecasting – DuckDB 7910
- 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
...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...allowed. For example, it is possible to explicitly cast a numeric type with fractional digits – such as DECIMAL , FLOAT or DOUBLE – to an integral type like INTEGER or BIGINT . The number will be rounded. SELECT CAST ( 3.1 AS INTEGER ); -- 3 SELECT CAS... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Import from Numpy – DuckDB 7794
- 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
...), ( 3 , 7.0 )]) duckdb . sql ( "SELECT * FROM my_arr" ) ┌─────────┬─────────┬─────────┐ │ column0 │ column1 │ column2 │ │ double │ double │ double │ ├─────────┼─────────┼─────────┤ │ 1.0 │ 2.0 │ 3.0 │ │ 9.0 │ 8.0 │ 7.0 │ └─────────┴─────────┴─────────...┘ See Also DuckDB also supports exporting to Numpy . 関連キーワード Numpy DuckDB column double arrays import duckdb Documentation Guides Copy Markdown Import query There need register manually find them process thanks... - https://man.mtool.work/duckdb/1.3/guides/python/import_numpy.html
- C++ API – DuckDB 7692
- 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
...NT int16_t → LogicalType::SMALLINT int32_t → LogicalType::INTEGER int64_t → LogicalType::BIGINT float → LogicalType::FLOAT double → LogicalType::DOUBLE string_t → LogicalType::VARCHAR In DuckDB some primitive types, e.g., int32_t , are mapped to the sa...alTypeId::INTEGER → int32_t LogicalTypeId::BIGINT, LogicalTypeId::TIMESTAMP → int64_t LogicalTypeId::FLOAT, LogicalTypeId::DOUBLE, LogicalTypeId::DECIMAL → double LogicalTypeId::VARCHAR, LogicalTypeId::CHAR, LogicalTypeId::BLOB → string_t LogicalTypeId...T; int16_t → LogicalType::SMALLINT int32_t → LogicalType::INTEGER int64_t → LogicalType::BIGINT float → LogicalType::FLOAT double → LogicalType::DOUBLE string_t → LogicalType::VARCHAR 2. template < typename TR , typename ... Args > void CreateVectorize... - https://man.mtool.work/duckdb/1.3/clients/cpp.html
DuckDB 1.3 Documentation / man.mtool.work