Results of 1 - 10 of about 116 for integer (0.006 sec.)
- Interval Functions – DuckDB 11576
- 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
...e_part . epoch(interval) Get total number of seconds, as double precision floating point number, in interval. to_centuries(integer) Construct a century interval. to_days(integer) Construct a day interval. to_decades(integer) Construct a decade interval....to_hours(integer) Construct an hour interval. to_microseconds(integer) Construct a microsecond interval. to_millennia(integer) Construct a...millennium interval. to_milliseconds(integer) Construct a millisecond interval. to_minutes(integer) Construct a minute interval. to_months(integer) Construct a month i... - https://man.mtool.work/duckdb/1.3/sql/functions/interval.html
- CREATE TABLE Statement – DuckDB 11237
- 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
...arkdown CREATE TABLE Statement The CREATE TABLE statement creates a table in the catalog. Examples Create a table with two integer columns ( i and j ): CREATE TABLE t1 ( i INTEGER , j INTEGER ); Create a table with a primary key: CREATE TABLE t1 ( id IN...TEGER PRIMARY KEY , j VARCHAR ); Create a table with a composite primary key: CREATE TABLE t1 ( id INTEGER , j VARCHAR , PRIMARY KEY ( id , j )); Create a table with various different types and constraints: CREATE TABLE t1 ( i IN...by the new table. This is shorthand for dropping the existing table and then creating the new one. Create a table with two integer columns (i and j) even if t1 already exists: CREATE OR REPLACE TABLE t1 ( i INTEGER , j INTEGER ); IF NOT EXISTS The IF NO... - https://man.mtool.work/duckdb/1.3/sql/statements/create_table.html
- INSERT Statement – DuckDB 11100
- 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 the default option, that can be explicitly specified using the BY POSITION option. For example: CREATE TABLE tbl ( a INTEGER , b INTEGER ); INSERT INTO tbl VALUES ( 5 , 42 ); Specifying BY POSITION is optional and is equivalent to the default beha...5 , 42 ); To use a different order, column names can be provided as part of the target, for example: CREATE TABLE tbl ( a INTEGER , b INTEGER ); INSERT INTO tbl ( b , a ) VALUES ( 5 , 42 ); Adding BY POSITION results in the same behavior: INSERT INTO t...ers from the order of the values in the SELECT statement or certain columns are missing. For example: CREATE TABLE tbl ( a INTEGER , b INTEGER ); INSERT INTO tbl BY NAME ( SELECT 42 AS b , 32 AS a ); INSERT INTO tbl BY NAME ( SELECT 22 AS b ); SELECT *... - https://man.mtool.work/duckdb/1.3/sql/statements/insert.html
- Literal Types – DuckDB 10774
- 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
...Demo Documentation / SQL / Data Types Copy Markdown Literal Types 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 INTEGER and VARCHAR types. Null Literals The NULL literal is denoted with the keyword NULL . The NULL literal can be implicitly co...nverted 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 INTEG... - https://man.mtool.work/duckdb/1.3/sql/data_types/literal_types.html
- Data Types – DuckDB 9934
- 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
...d and hence might not be accepted by other database engines. Name Aliases Description BIGINT INT8 , LONG Signed eight-byte integer BIT BITSTRING String of 1s and 0s BLOB BYTEA , BINARY, VARBINARY Variable-length binary data BOOLEAN BOOL , LOGICAL Logica...ng-point number (8 bytes) FLOAT FLOAT4 , REAL Single precision floating-point number (4 bytes) HUGEINT Signed sixteen-byte integer INTEGER INT4 , INT , SIGNED Signed four-byte integer INTERVAL Date / time delta JSON JSON object (via the json extension )...SMALLINT INT2 , SHORT Signed two-byte integer TIME Time of day (no time zone) TIMESTAMP WITH TIME ZONE TIMESTAMPTZ Combination of time and date that uses the current ti... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Typecasting – DuckDB 8995
- 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
...pe combinations, 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 c...olumn of type DOUBLE , however, it can be called with an integer as well: sin(1) . The integer is converted into a double before being passed to the sin function. Tip To check whether a t...le 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 ); -- 4 SELECT C... - https://man.mtool.work/duckdb/1.3/sql/data_types/typecasting.html
- PostgreSQL Compatibility – DuckDB 8619
- 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 1.0 / 'Infinity' 0.0 0.0 0.0 'Infinity' - 'Infinity' NaN NaN NaN 'Infinity' - 1.0 Infinity Infinity Infinity Division on Integers When computing division on integers, PostgreSQL performs integer division, while DuckDB performs float division: SELECT 1.../ 2 AS x ; PostgreSQL returns 0 , while DuckDB returns 0.5 . To perform integer division in DuckDB, use the // operator: SELECT 1 // 2 AS x ; This returns 0 . UNION of Boolean and Integer Values The fol...ssfully completes in DuckDB: SELECT true AS x UNION SELECT 2 ; PostgreSQL returns an error: ERROR: UNION types boolean and integer cannot be matched DuckDB performs an enforced cast, therefore, it completes the query and returns the following: x 1 2 Imp... - https://man.mtool.work/duckdb/1.3/sql/dialect/postgresql_compatibility.html
- Text Functions – DuckDB 8105
- 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
...gin, end) Extracts a sublist or substring using slice conventions . Negative values are accepted. ascii(string) Returns an integer that represents the Unicode code point of the first character of the string . bar(x, min, max[, width]) Draws a band whose...if string ends with search_string . format(format, ...) Formats a string using the fmt syntax . formatReadableDecimalSize(integer) Converts integer to a human-readable representation using units based on powers of 10 (KB, MB, GB, etc.). formatReadableS...ize(integer) Converts integer to a human-readable representation using units based on powers of 2 (KiB, MiB, GiB, etc.). format_bytes(... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Struct Data Type – DuckDB 7955
- 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
...; Create a struct using a row variable: SELECT d AS s FROM ( SELECT 'value1' AS key1 , 42 AS key2 ) d ; Create a struct of integers: SELECT { 'x' : 1 , 'y' : 2 , 'z' : 3 } AS s ; Create a struct of strings with a NULL value: SELECT { 'yes' : 'duck' , 'm...maybe' : 'salamander' , 'huh' : 'dragon' , 'no' : 'toad' } } AS s ; Adding Field(s)/Value(s) to Structs Add to a struct of integers: SELECT struct_insert ({ 'a' : 1 , 'b' : 2 , 'c' : 3 }, d : = 4 ) AS s ; Retrieving from Structs Retrieving a value from...med. For example, inserting values into a struct column using the row function: CREATE TABLE t1 ( s STRUCT ( v VARCHAR , i INTEGER )); INSERT INTO t1 VALUES ( row ( 'a' , 42 )); SELECT * FROM t1 ; The table will contain a single entry: { 'v' : a , 'i' :... - https://man.mtool.work/duckdb/1.3/sql/data_types/struct.html
- Numeric Types – DuckDB 7767
- 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
...Versions and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Numeric Types Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional...s ranges. Attempts to store values outside of the allowed range will result in an error. The types UTINYINT , USMALLINT , UINTEGER , UBIGINT and UHUGEINT store whole unsigned numbers. Attempts to store negative numbers or values outside of the allowed r...an error. Name Aliases Min Max Size in bytes TINYINT INT1 - 2^7 2^7 - 1 1 SMALLINT INT2 , INT16 , SHORT - 2^15 2^15 - 1 2 INTEGER INT4 , INT32 , INT , SIGNED - 2^31 2^31 - 1 4 BIGINT INT8 , INT64 , LONG - 2^63 2^63 - 1 8 HUGEINT INT128 - 2^127 2^127 -... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
DuckDB 1.3 Documentation / man.mtool.work