Results of 1 - 10 of about 13 for digits (0.002 sec.)
- Numeric Types 13618
- 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
...ned, 8-bit integer. The type aliases INT1 , INT2 , INT4 and INT8 for signed integers were inherited from PostgreSQL, where digits in these names indicate their size in bytes , whereas the type aliases for their unsigned equivalents, UINT8 , UINT16 , UI...as other integer types, but uses three additional bytes to store the required size and a sign bit. A number with N decimal digits requires approximately 0.415 * N + 3 bytes when stored in a BIGNUM . Unlike variable-length integer implementations in oth...the maximal and minimal representable values are approximately ±4.27e20201778 . 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 avai... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- marimo Notebooks 11102
- marimo is an open-source reactive notebook for Python and SQL that's tightly integrated with DuckDB's Python client, letting you mix and match Python and SQL in a single git-versionable notebook. Unlike traditional notebooks, when you run a
...e to be “lazy”. By doing so, dependent cells are only marked as stale, letting the user choose when they should be re-run. digits = mo.ui.slider(label="Digits", start=100, stop=10000, step=200) digits CREATE TABLE random_data AS SELECT i AS id, random(...) AS random_value, FROM range({digits.value}) AS t(i); SELECT * FROM random_data; Interacting with UI elements, like a slider, makes your data more tangible. Du... - https://man.mtool.work/duckdb/2.0/guides/python/marimo.html
- Blob Type 10047
- Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents an arbitrary binary object stored in the database system. The blob type can contain any type of binary d
...(65, 66): SELECT 'AB'::BLOB; A BLOB value can also be created using a hex string literal, which is a string of hexadecimal digits prefixed with X . The number of hex digits must be even. For example, create a BLOB value with two bytes (202, 254): SELEC... - https://man.mtool.work/duckdb/2.0/sql/data_types/blob.html
- Information Schema 8868
- The views in the information_schema are SQL-standard views that describe the catalog entries of the database. These views can be filtered to obtain information about a specific column or table. DuckDB's implementation is based on PostgreSQL
...ntains the (declared or implicit) precision of the type for this column. The precision indicates the number of significant digits. For all other data types, this column is NULL . INTEGER 18 numeric_scale If data_type identifies a numeric type, this col...umn contains the (declared or implicit) scale of the type for this column. The scale indicates the number of digits after the decimal point. For all other data types, this column is NULL . INTEGER 2 datetime_precision If data_type identif...ntains the (declared or implicit) fractional seconds precision of the type for this column, that is, the number of decimal digits maintained following the decimal point in the seconds value. No fractional seconds are currently supported in DuckDB. For... - https://man.mtool.work/duckdb/2.0/sql/meta/information_schema.html
- Conversion between DuckDB and Python 8604
- This page documents the rules for converting DuckDB results to Python and Python objects to DuckDB . Result Conversion: DuckDB Results to Python A result is read from a relation or, when using the DB-API / con.execute() , from the connectio
...d read its bytes in order, here b'ace' . decimal.Decimal A Decimal becomes a DECIMAL whose width and scale follow from its digits and its exponent: Decimal("12.5") is a DECIMAL(3,1) , Decimal("1E+2") is a DECIMAL(3,0) that holds 100 and Decimal("1E-7")...is a DECIMAL(8,7) . A value that needs more than 38 digits becomes a DOUBLE , such as Decimal("1E+38") or Decimal(0.1) , which holds the 55 decimal digits of the binary float 0.1. N... - https://man.mtool.work/duckdb/2.0/clients/python/conversion.html
- Literal Types 8604
- 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
...implicitly converted to any other type. Integer Literals Integer literals are denoted as a sequence of one or more decimal digits. At runtime, these result in values of the INTEGER_LITERAL type. INTEGER_LITERAL types can be implicitly converted to any...iteral prefixed with X is a hex string literal, which produces a BLOB value. It must contain an even number of hexadecimal digits. SELECT B'0101' AS b, X'CAFE' AS x; ┌──────┬──────────┐ │ b │ x │ │ bit │ blob │ ├──────┼──────────┤ │ 0101 │ \xCA\xFE │ └... - https://man.mtool.work/duckdb/2.0/sql/data_types/literal_types.html
- Dot Commands 7935
- 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
...schema .thousand_sep ⟨SEP⟩ Set the thousand separator 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 sep... - https://man.mtool.work/duckdb/2.0/clients/cli/dot_commands.html
- ODBC Extension Functions 7935
- 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) ->
...( TIMESTAMP WITH LOCAL TIME ZONE , DATETIME2 , TIMESTAMP_NTZ etc) columns with nanosecond precision (with nine fractional digits) timestamp_columns_with_typename_date_as_date ( BOOLEAN , default: false ): read TIMESTAMP columns that have a type name D...ATE as DuckDB DATE s timestamp_max_fraction_precision ( UTINYINT , default: 9 ): maximum number of fractional digits to use when reading a TIMESTAMP column with nanosecond precision timestamp_params_as_sf_timestamp_ntz ( BOOLEAN , default:... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Go Client 7671
- The latest stable release of the DuckDB Go client bundles DuckDB 2.0.0. Its own version tag encodes that DuckDB version; see Versioning below. The DuckDB Go client, duckdb-go , is a SQL driver that conforms to Go's built-in database/sql int
...That component is the DuckDB major , minor , and patch numbers concatenated, with minor and patch each zero-padded to two digits: DuckDB 1.5.0 maps to duckdb-go v2.10500.x, and DuckDB 2.0.0 maps to v2.20000.0. The README has the full mapping table for... - https://man.mtool.work/duckdb/2.0/clients/go/overview.html
- DuckDB_% Metadata Functions 7671
- 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
...number of decimal positions. INTEGER numeric_scale Applicable 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 vi... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
DuckDB 2.0 Documentation / man.mtool.work