Results of 1 - 10 of about 28 for aliases (0.017 sec.)
- Text Functions – DuckDB 12044
- 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
...h('abc') Result 24 char_length(string) Description Number of characters in string . Example char_length('Hello?') Result 6 Aliases character_length , len , length character_length(string) Description Number of characters in string . Example character_le...ngth('Hello?') Result 6 Aliases char_length , len , length chr(code_point) Description Returns a character which is corresponding the ASCII code value or...rence of search_string in string , counting from 1. Returns 0 if no match found. Example instr('test test', 'es') Result 2 Aliases position , strpos lcase(string) Description Converts string to lower case. Example lcase('Hello') Result hello Alias lower... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Friendly SQL – DuckDB 11503
- 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
...pression. UNION BY NAME : perform the UNION operation along the names of columns (instead of relying on positions). Prefix aliases in the SELECT and FROM clauses : write x: 42 instead of 42 AS x for improved readability. Specifying a percentage of the t...NPIVOT to turn wide tables to long tables. Defining SQL-level variables: SET VARIABLE RESET VARIABLE Query Features Column aliases in WHERE , GROUP BY , and HAVING . (Note that column aliases cannot be used in the ON clause of JOIN clauses .) COLUMNS()...me expression on multiple columns: with regular expressions with EXCLUDE and REPLACE with lambda functions Reusable column aliases (also known as “lateral column aliases”), e.g.: SELECT i + 1 AS j, j + 2 AS k FROM range(0, 3) t(i) Advanced aggregation f... - https://man.mtool.work/duckdb/1.3/sql/dialect/friendly_sql.html
- List Functions – DuckDB 11323
- 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
...elements of list . See the List Aggregates section for more details. Example list_aggregate([1, 2, NULL], 'min') Result 1 Aliases list_aggr , aggregate , array_aggregate , array_aggr list_any_value(list) Description Returns the first non-null value in...Result -3 list_append(list, element) Description Appends element to list . Example list_append([2, 3], 4) Result [2, 3, 4] Aliases array_append , array_push_back list_concat(list1, ..., listn) Description Concatenates lists. NULL inputs are skipped. See...also || Example list_concat([2, 3], [4, 5, 6], [7]) Result [2, 3, 4, 5, 6, 7] Aliases list_cat , array_concat , array_cat list_contains(list, element) Description Returns true if the list contains the element... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Numeric Types – DuckDB 10241
- 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
...unsigned numbers. Attempts to store negative numbers or values outside of the allowed range will result in 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 ,...0 2^128 - 1 16 INT8 is a 64-bit integer, and is not the signed equivalent of UINT8 , an unsigned, 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 , UINT32 and UINT64 , indicate their size in bits following the C/C++ conve... - https://man.mtool.work/duckdb/1.3/sql/data_types/numeric.html
- Data Types – DuckDB 10061
- 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
...neral-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL standard and he...nce 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...ger values different union Types Signed number keys scale precision time used length date prec nested Rules multiple table aliases column Description 関連するページ Map Type Numeric Types Union Type CREATE TYPE Statement Writing Tests Time Types See thi... - https://man.mtool.work/duckdb/1.3/sql/data_types/overview.html
- Map Functions – DuckDB 9700
- 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
...t match the type of the map's keys; else, an error is thrown. Example element_at(map([100, 5], [42, 43]), 100) Result [42] Aliases map_extract(map, key) map_concat(maps...) Description Returns a map created from merging the input maps . On key collision...match the type of the map's keys else an error is returned. Example map_extract(map([100, 5], [42, 43]), 100) Result [42] Aliases element_at(map, key) map_extract_value(map, key) Description Returns the value for a given key or NULL if the key is not c...h the type of the map's keys; else, an error is thrown. Example map_extract_value(map([100, 5], [42, 43]), 100); Result 42 Aliases map[key] map_from_entries(STRUCT(k, v)[]) Description Returns a map created from the entries of the array. Example map_fro... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- Window Functions – DuckDB 9504
- 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
...iption The rank of the current row without gaps; this function counts peer groups. Return type BIGINT Example dense_rank() Aliases rank_dense() first_value(expr[ ORDER BY ordering][ IGNORE NULLS]) Description Returns expr evaluated at the row that is th...mber is computed within the frame using the provided ordering instead of the frame ordering. Return type Same type as expr Aliases lag(column, 3, 0) last_value(expr[ ORDER BY ordering][ IGNORE NULLS]) Description Returns expr evaluated at the row that i...mber is computed within the frame using the provided ordering instead of the frame ordering. Return type Same type as expr Aliases lead(column, 3, 0) nth_value(expr, nth[ ORDER BY ordering][ IGNORE NULLS]) Description Returns expr evaluated at the nth r... - https://man.mtool.work/duckdb/1.3/sql/functions/window_functions.html
- Relational API – DuckDB 9323
- 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
...bject , ** kwargs ) -> duckdb . duckdb . DuckDBPyRelation Description Create a relation object from the CSV file in 'name' Aliases : read_csv Parameters path_or_buffer : Union[str, StringIO, TextIOBase] Path to the CSV file or buffer to read from. heade...Create a relation object from the Parquet files in file_globs Description Create a relation object from the Parquet files Aliases : read_parquet Parameters file_glob : str File path or glob pattern pointing to Parquet files to be read. binary_as_string...SQL query. If it is a SELECT statement, create a relation object from the given SQL query, otherwise run the query as-is. Aliases : query , sql Parameters query : object The SQL query or subquery to be executed and converted into a relation. alias : st... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Bitstring Type – DuckDB 8422
- 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
...ons and Format Execution Format Pivot Sitemap Live Demo Documentation / SQL / Data Types Copy Markdown Bitstring Type Name Aliases Description BITSTRING BIT Variable-length strings of 1s and 0s Bitstrings are strings of 1s and 0s. The bit type data is o...ーワード bitstring Bitstring length strings Bitstrings padded zeroes values Functions Documentation Types Copy Markdown Type Aliases Description Variable type variable requires byte group bits plus fixed 関連するページ Bitstring Functions Text Types Funct... - https://man.mtool.work/duckdb/1.3/sql/data_types/bitstring.html
- Blob Type – DuckDB 8422
- 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 Blob Type Name Aliases Description BLOB BYTEA , BINARY , VARBINARY Variable-length binary data The blob ( B inary L arge OB ject) type represents...stem store binary type bytes Create objects Blob blob xAA typically large Functions Documentation Types Copy Markdown Type Aliases Description Variable length inary arge 関連するページ Blob Functions CREATE TYPE Statement Numeric Types Nested Functions... - https://man.mtool.work/duckdb/1.3/sql/data_types/blob.html
DuckDB 1.3 Documentation / man.mtool.work