Results of 1 - 6 of about 6 for integral (0.002 sec.)
- Loops 13033
- Loops can be used in sqllogictests when it is required to execute the same query many times but with slight modifications in constant values. For example, suppose we want to fire off 100 queries that check for the presence of the values 0..
...fsst chimp patas ⟨signed⟩ tinyint smallint integer bigint hugeint ⟨unsigned⟩ utinyint usmallint uinteger ubigint uhugeint ⟨integral⟩ ⟨signed⟩ ⟨unsigned⟩ ⟨numeric⟩ ⟨integral⟩ float double ⟨alltypes⟩ ⟨numeric⟩ bool interval varchar json Use large loops spa... - https://man.mtool.work/duckdb/2.0/dev/sqllogictest/loops.html
- ODBC Extension Functions 9304
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...rs (query parameters handling): decimal_params_as_chars ( BOOLEAN , default: false ): pass DECIMAL parameters as VARCHAR s integral_params_as_decimals ( BOOLEAN , default: false ): pass (unsigned) TINYINT , SMALLINT , INTEGER and BIGINT parameters as SQL...D_TYPE instead of SQL_C_NUMERIC decimal_params_as_chars ( BOOLEAN , default: false ): pass DECIMAL parameters as VARCHAR s integral_params_as_decimals ( BOOLEAN , default: false ): pass (unsigned) TINYINT , SMALLINT , INTEGER and BIGINT parameters as SQL... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- DuckDB_% Metadata Functions 8627
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...eric_precision The number of units (in the base indicated by numeric_precision_radix ) used for storing column values. For integral and approximate numeric types, this is the number of bits. For decimal types, this is the number of digit positions. INTEG...ER numeric_precision_radix The number-base of the units in the numeric_precision column. For integral and approximate numeric types, this is 2 , indicating the precision is expressed as a number of bits. For the decimal type... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- Typecasting 8280
- 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
...ample, 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 CAST(3.5 AS INTEGER); -... - https://man.mtool.work/duckdb/2.0/sql/data_types/typecasting.html
- Numeric Functions 7933
- 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
...NULL result for all divisions by zero. Supported Types The bitwise, bitwise negation, and factorial operators work only on integral data types, whereas the others are available for all numeric data types. Numeric Functions The table below shows the avail... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Window Functions 7604
- DuckDB supports window functions , which can use multiple rows to calculate a value for each row. Window functions are blocking operators , i.e., they require their entire input to be buffered, making them one of the most memory-intensive o
...t row in the order specified by the ORDER BY clause in the OVER specification. This distance can either be specified as an integral number of ROWS or GROUPS , or as a RANGE delta expression. It is invalid for a frame to start after it ends. For a RANGE s... - https://man.mtool.work/duckdb/2.0/sql/functions/window_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work