Results of 1 - 7 of about 7 for decimals (0.002 sec.)
- Numeric Types 13432
- 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
...1778 . Those are numbers with 20,201,779 decimal digits and storing a single such number requires 8 megabytes. Fixed-Point Decimals The data type DECIMAL(WIDTH, SCALE) (also available under the alias NUMERIC(WIDTH, SCALE) ) represents an exact fixed-poin...ters (INTEGER, INTEGER) Arithmetic and Internal Representation Addition, subtraction and multiplication of two fixed-point decimals returns another fixed-point decimal with the required WIDTH and SCALE to contain the exact result, or throws an error if t...he required WIDTH would exceed the maximal supported WIDTH , which is currently 38. Division of fixed-point decimals does not typically produce numbers with finite decimal expansion. Therefore, DuckDB uses approximate floating-point arithm... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Vectors 9033
- Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representation used in DuckDB. Vectors are typically stored within data chunks . The vector an
...; The length can either be accessed directly, or the duckdb_string_is_inlined can be used to check if a string is inlined. Decimals Decimals are stored as integer values internally. The exact native type depends on the width of the decimal type, as shown...= 18 int64_t <= 38 duckdb_hugeint The duckdb_decimal_internal_type can be used to obtain the internal type of the decimal. Decimals are stored as integer values multiplied by 10^scale . The scale of a decimal can be obtained using duckdb_decimal_scale .... - https://man.mtool.work/duckdb/2.0/clients/c/vector.html
- ODBC Extension Functions 8688
- 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) ->
...s 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_C_NUMERIC . Option...uration: decimal_columns_as_chars ( BOOLEAN , default: false ): read DECIMAL values as VARCHAR s that are parsed back into DECIMAL s before returning them to client decimal_columns_precision_through_ard ( BOOLEAN , default: false ): when reading a DECIMA...QL_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_C_NUMERIC . reset_... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Types 8360
- 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
...ost primitive types, e.g., integers or varchars, the enum is sufficient. For more complex types, such as lists, structs or decimals, the logical type must be used. typedef enum DUCKDB_TYPE { DUCKDB_TYPE_INVALID = 0, DUCKDB_TYPE_BOOLEAN = 1, DUCKDB_TYPE_T...alue functions do not support structural reading of composite types (lists or structs) or more complex types like enums or decimals. For more information about data chunks, see the documentation on data chunks . API Reference Overview duckdb_data_chunk d... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Quack Remote Protocol 8179
- The Quack extension turns a DuckDB instance into a server that other DuckDB instances (clients) can connect to over HTTP. This page covers the protocol at a glance and walks through basic usage on both sides of the wire. For the full list o
...d by the Write-Ahead Log ). This avoids round-tripping data through an interchange format and keeps complex types (nested, decimals, intervals, ...) lossless across the wire. Single round-trip per query. After the initial connection handshake, a query ne... - https://man.mtool.work/duckdb/2.0/quack/overview.html
- Dot Commands 8015
- Dot commands are available in the DuckDB CLI client. To use one of these commands, begin the line with a period ( . ) immediately followed by the name of the command you wish to execute. Additional arguments to the command are entered, spac
...command executed by the -connect argument .databases List names and files of attached databases .decimal_sep ⟨SEP⟩ Set the decimal separator used when rendering numbers. Only for duckbox mode .dump ⟨TABLE⟩ Render database content as SQL. TABLE is a LIKE...parator used when rendering numbers. Only for duckbox mode .timer ⟨on/off⟩ ⟨DIGITS⟩ Turn SQL timer on or off , with DIGITS decimals for the real time (default: 3). SQL statements separated by ; but not separated via newline are measured together .ui_comm... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- DuckDB_% Metadata Functions 7852
- 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
...e to decimal type. Indicates the maximum number of fractional digits (i.e., the number of digits that may appear after the decimal separator). INTEGER The information_schema.columns system view provides a more standardized way to obtain metadata about da...milar behavior when values of this type are used in expressions. For example, the NUMERIC type_category includes integers, decimals and floating point numbers. VARCHAR comment A comment created by the COMMENT ON statement . VARCHAR tags A map of string k... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work