Results of 1 - 10 of about 12 for concat (0.009 sec.)
- Relational API – DuckDB 14486
- 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
...lias Example import duckdb duckdb_conn = duckdb . connect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,...ion. Example import duckdb duckdb_conn = duckdb . connect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,...ion. Example import duckdb duckdb_conn = duckdb . connect () rel = duckdb_conn . sql ( """ select gen_random_uuid() as id, concat('value is ', case when mod(range,2)=0 then 'even' else 'uneven' end) as description, range as value, now() + concat(range,... - https://man.mtool.work/duckdb/1.3/clients/python/relational_api.html
- Blob Functions – DuckDB 9586
- 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
...This section describes functions and operators for examining and manipulating BLOB values . Name Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list...1, list2) . base64(blob) Converts a blob to a base64 encoded string. concat(value, ...) Concatenates multiple strings, lists, or blobs. NULL inputs are skipped. See also operator || . decode(blob) C...epresentation to a blob. unhex(value) Converts a value from hexadecimal representation to a blob. arg1 || arg2 Description Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list... - https://man.mtool.work/duckdb/1.3/sql/functions/blob.html
- Struct Functions – DuckDB 8667
- 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
...(tuples), using an index (1-based). row(any, ...) Create an unnamed STRUCT (tuple) containing the argument values. struct_concat(structs...) Merge the multiple structs into a single STRUCT . struct_extract(struct, 'entry') Extract the named entry from...n Create an unnamed STRUCT (tuple) containing the argument values. Example row(i, i % 4, i / 4) Result (10, 2, 2.5) struct_concat(structs...) Description Merge the multiple structs into a single STRUCT . Example struct_concat(struct_pack(i := 4), struc...alias named unnamed using index based tuple argument values Extract pack Bracket Create containing structs bound variable concat 関連するページ Union Functions Struct Data Type Map Functions List Functions Interval Functions Time Functions See this pa... - https://man.mtool.work/duckdb/1.3/sql/functions/struct.html
- Text Functions – DuckDB 8667
- 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
...the regex (see Pattern Matching ). string ^@ search_string Returns true if string begins with search_string . arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list...racters in string . chr(code_point) Returns a character which is corresponding the ASCII code value or Unicode code point. concat(value, ...) Concatenates multiple strings, lists, or blobs. NULL inputs are skipped. See also operator || . concat_ws(sepa...rator, string, ...) Concatenates many strings, separated by separator . NULL inputs are skipped. contains(string, search_string) Returns true if sear... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Lambda Functions – DuckDB 8437
- 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
...have any names. For example, the following are all valid lambda functions: lambda param : param > 1 lambda s : contains ( concat ( s , 'DB' ), 'duck' ) lambda acc , x : acc + x Scalar Functions That Accept Lambda Functions Name Description list_transf...bda x : x + 1 ); [2, 3, NULL, 4] Transforming strings: SELECT list_transform ([ 'Duck' , 'Goose' , 'Sparrow' ], lambda s : concat ( s , 'DB' )); [DuckDB, GooseDB, SparrowDB] Combining lambda functions with other functions: SELECT list_transform ([ 5 ,...are greater than 2: SELECT list_reduce ( list_filter ([ 1 , 2 , 3 , 4 ], lambda x : x > 2 ), lambda acc , x : acc + x ); 7 Concat all list elements: SELECT list_reduce ([ 'DuckDB' , 'is' , 'awesome' ], lambda acc , x : concat ( acc , ' ' , x )); DuckDB... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
- Map Functions – DuckDB 8295
- 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
...The type of the key provided in the second parameter must match the type of the map's keys; else, an error is thrown. map_concat(maps...) Returns a map created from merging the input maps . On key collision the value is taken from the last map with th...; 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 the value is taken from the last...map with that key. Example map_concat(MAP {'key1': 10, 'key2': 20}, MAP {'key3': 30}, MAP {'key2': 5}) Result {key1=10, key2=5, key3=30} map_contains(map, key)... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- List Functions – DuckDB 8260
- 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
...he list without the last element. array_pop_front(list) Returns the list without the first element. flatten(list_of_lists) Concatenate a list of lists into a single list. This only flattens one level of the list (see examples ). len(list) Return the le...st_any_value(list) Returns the first non-null value in the list. list_append(list, element) Appends element to list . list_concat(list1, ..., listn) Concatenate lists. NULL inputs are skipped. See also || list_contains(list, element) Returns true if th...ns the list without the first element. Example array_pop_front([4, 5, 6]) Result [5, 6] flatten(list_of_lists) Description Concatenate a list of lists into a single list. This only flattens one level of the list (see examples ). Example flatten([[1, 2]... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- SQL Quirks – DuckDB 8065
- 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
...eSQL. 1 IN (0, NULL) NULL Makes sense if you think of the NULL s in the input and output as UNKNOWN . 1 in [0, NULL] false concat('abc', NULL) abc Compatible with PostgreSQL. list_concat behaves similarly. 'abc' || NULL NULL NaN Values 'NaN'::FLOAT = '... - https://man.mtool.work/duckdb/1.3/sql/dialect/sql_quirks.html
- ALTER TABLE Statement – DuckDB 8030
- 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
...using the specified expression to convert the data for each row: ALTER TABLE integers ALTER i SET DATA TYPE VARCHAR USING concat ( i , '_' , j ); Set the default value of a column: ALTER TABLE integers ALTER COLUMN i SET DEFAULT 10 ; Drop the default...using the specified expression to convert the data for each row: ALTER TABLE integers ALTER i SET DATA TYPE VARCHAR USING concat ( i , '_' , j ); The [SET [DATA]] TYPE clause changes the type of a column in a table. Any data present in the column is c... - https://man.mtool.work/duckdb/1.3/sql/statements/alter_table.html
- Aggregate Functions – DuckDB 7941
- 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
...tive aggregates that can have non-deterministic results without ordering, e.g., first , last , list and string_agg / group_concat / listagg . These can be made deterministic by ordering the arguments. For example: CREATE TABLE tbl AS SELECT s FROM rang...ttom" n rows ordered by val ascending. product(arg) Calculates the product of all non-null values in arg . string_agg(arg) Concatenates the column string values with a comma separator ( , ). This function is affected by ordering . string_agg(arg, sep)...cription Calculates the product of all non-null values in arg . Example product(A) Alias(es) - string_agg(arg) Description Concatenates the column string values with a comma separator ( , ). This function is affected by ordering . Example string_agg(S,... - https://man.mtool.work/duckdb/1.3/sql/functions/aggregates.html
DuckDB 1.3 Documentation / man.mtool.work