Results of 1 - 10 of about 13 for concat (0.005 sec.)
- List Functions 12897
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...as for list_cosine_distance . list1 <@ list2 Alias for list_has_all . list1 @> list2 Alias for list_has_all . arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list...as for list_append . array_apply(list, lambda(x)) Alias for list_transform . array_cat(list_1, ..., list_n) Alias for list_concat . array_concat(list_1, ..., list_n) Alias for list_concat . array_contains(list, element) Alias for list_contains . array_...end, step) Alias for list_slice . array_sort(list[, col1][, col2]) Alias for list_sort . array_to_string(list, delimiter) Concatenates list/array elements using an optional delimiter . array_to_string_comma_default(array) Concatenates list/array eleme... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
- Blob Functions 10539
- This section describes functions and operators for examining and manipulating BLOB values . Function Description arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and l
...ist_concat(list1, list2, ...) . base64(blob) Alias for to_base64 . decode(blob[, on_error]) Converts blob to VARCHAR . The optional o...sentation 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/2.0/sql/functions/blob.html
- Text Functions 10539
- Text Functions and Operators This section describes functions and operators for examining and manipulating STRING values . Function Description string[index] Extracts a single character using a (1-based) index . string[begin:end] Extracts a
...true if the string matches the regex (see Pattern Matching ). string ^@ search_string Alias for starts_with . arg1 || arg2 Concatenates two strings, lists, or blobs. Any NULL input results in NULL . See also concat(arg1, arg2, ...) and list_concat(list...Alias for length . chr(code_point) Returns a character which is corresponding the ASCII code value or Unicode code point. concat(value, ...) Concatenates multiple strings or lists. NULL inputs are skipped. See also operator || . concat_ws(separator, s...tring, ...) Concatenates many strings, separated by separator . NULL inputs are skipped. contains(string, search_string) Returns true if sear... - https://man.mtool.work/duckdb/2.0/sql/functions/text.html
- Struct Functions 9923
- The functions on this page work on STRUCT values . Functions that access entries by position, such as struct[idx] , struct_extract_at , struct_contains , struct_position and struct_values , also accept TUPLE values , i.e., structs with unna
...med entries. struct_concat accepts either only STRUCT s or only TUPLE s. Functions that work with entry names, i.e., struct_insert , struct_keys , st...sted types, and filling missing fields from defaults . row(any, ...) Create a TUPLE containing the argument values. struct_concat(structs...) Merge the multiple structs into a single STRUCT . struct_contains(struct, entry) Check if the STRUCT contains...ion | Create a 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 :=... - https://man.mtool.work/duckdb/2.0/sql/functions/struct.html
- Lambda Functions 9448
- DuckDB lambda functions (a.k.a. 'lambdas' or 'lambda expressions') are expressions that define an inline anonymous function. Lambdas are passed as argument to certain list functions , which evaluate the passed lambda expression against its
...ely on a subquery. 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 Lambda functions enable the use of more complex and flexible expressions in quer...3], lambda 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, NULL, 6...ts if they 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 is awesome... - https://man.mtool.work/duckdb/2.0/sql/functions/lambda.html
- Map Functions 8973
- Name Description cardinality(map) Return the size of the map (or the number of entries in the map). element_at(map, key) Return the value for a given key as a list, or an empty list if the key is not contained in the map. The type of the ke
...y 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...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(ma... - https://man.mtool.work/duckdb/2.0/sql/functions/map.html
- SQL Quirks 8516
- Like all programming languages and libraries, DuckDB has its share of idiosyncrasies and inconsistencies. Some are vestiges of our feathered friend's evolution; others are inevitable because we strive to adhere to the SQL Standard and speci
...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/2.0/sql/dialect/sql_quirks.html
- ALTER TABLE Statement 7882
- The ALTER TABLE statement changes the schema of an existing table in the catalog. Examples CREATE TABLE integers (i INTEGER, j INTEGER); Add a new column with name k to the table integers , it will be filled with the default value NULL : AL
...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 value...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 conver... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_table.html
- Python Client API 7425
- Connection class duckdb. Appender Bases: object append_row ( self , * args ) → None Buffer one row, one value per column, each converted as an executemany parameter would be append_rows ( self , rows : object ) → None Buffer each row of an
...n : str , sep : str = ',' , groups : str = '' , window_spec : str = '' , projected_columns : str = '' ) → DuckDBPyRelation Concatenates the values present in a given expression with a separator. Detailed examples can be found at Relational API page . s.... collate ( collation : str ) → Expression Compare and sort by a collation, such as nocase ; nocase.noaccent combines two. concat ( * others : object ) → Expression Join text values. count ( * args : ValueOrExpr ) → Expression How many values are not N...] ] = {'ascii': ('ascii', 0, ['VARCHAR']), 'bin': ('bin', 0, ['VARCHAR']), 'bit_length': ('bit_length', 0, ['VARCHAR']), 'concat_ws': ('concat_ws', 1, ['VARCHAR', 'ANY']), 'contains': ('contains', 0, ['VARCHAR', 'VARCHAR']), 'damerau_levenshtein': ('d... - https://man.mtool.work/duckdb/2.0/clients/python/reference/
- Aggregate Functions 7425
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...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...roduct(arg) Calculates the product of all non-null values in arg . This function is affected by ordering . string_agg(arg) Concatenates the column string values with a comma separator ( , ). This function is affected by ordering . string_agg(arg, sep)...on-null values in arg . This function is affected by ordering . | | Example | product(A) | string_agg(arg) | Description | Concatenates the column string values with a comma separator ( , ). This function is affected by ordering . | | Example | string_... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
DuckDB 2.0 Documentation / man.mtool.work