Results of 1 - 8 of about 8 for digits (0.004 sec.)
- Numeric Types – DuckDB 13194
- 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
...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...ns the VARINT type can come in handy, as the VARINT type has a much bigger limit (the value can consist of up to 1,262,612 digits). The minimum storage size for a VARINT is 4 bytes, every digit takes up an extra bit, rounded up to 8 (12 digits take 12...CALE can be specified to define which size of decimal values can be held in the field. The WIDTH field determines how many digits can be held, and the scale determines the amount of digits after the decimal point. For example, the type DECIMAL(3, 2) ca... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- marimo Notebooks – DuckDB 10410
- 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
...me 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 SELEC...T 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 tangibl... - https://man.mtool.work/duckdb/1.3/guides/python/marimo.html
- Information Schema – DuckDB 9019
- 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
...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...n contains the (declared or implicit) scale of the type for this column. The precision indicates the number of significant digits. For all other data types, this column is NULL . INTEGER 2 datetime_precision If data_type identifies a date, time, timest...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/1.3/sql/meta/information_schema.html
- DuckDB_% Metadata Functions – DuckDB 8585
- 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
...n values. For integral and approximate numeric types, this is the number of bits. For decimal types, this is the number of digits positions. INTEGER numeric_precision_radix The number-base of the units in the numeric_precision column. For integral and...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/1.3/sql/meta/duckdb_table_functions.html
- Literal Types – DuckDB 7898
- 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
...can be implicitly converted to any other type. Integer Literals Integer literals are denoted as a sequence of one or more digits. At runtime, these result in values of the INTEGER_LITERAL type. INTEGER_LITERAL types can be implicitly converted to any... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Typecasting – DuckDB 7898
- 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
...hat result in loss of precision are 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... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- Regular Expressions – DuckDB 7753
- 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
...ted. Limitations Regular expressions only support 9 capture groups: \1 , \2 , \3 , …, \9 . Capture groups with two or more digits are not supported. 関連キーワード regexp matches options pattern extract regex hello group replace world optional Descript... - https://man.mtool.work/duckdb/1.3/sql/functions/regular_expressions.html
- Spatial Functions – DuckDB 7482
- 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
...ean argument specifies whether the path should be relative or absolute. The third argument specifies the maximum number of digits to use for the coordinates. Points are formatted as cx/cy using absolute coordinates or x/y using relative coordinates. Ex... - https://man.mtool.work/duckdb/1.3/core_extensions/spatial/functions.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work