Results of 1 - 10 of about 19 for element (0.005 sec.)
- List Functions – DuckDB 13745
- 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
...nd:step] list_slice in bracket notation with an added step feature. array_pop_back(list) Returns the 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...xamples ). len(list) Return the length of the list. list_aggregate(list, name) Executes the aggregate function name on the elements of list . See the List Aggregates section for more details. list_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_con... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- JSON Processing Functions – DuckDB 11457
- 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
...ocations within JSON: JSON Pointer and JSONPath. Function Description json_array_length(json[, path]) Return the number of elements in the JSON array json , or 0 if it is not a JSON array. If path is specified, return the number of elements in the JSON...f ARRAY , BIGINT , BOOLEAN , DOUBLE , OBJECT , UBIGINT , VARCHAR , and NULL . If path is specified, return the type of the element at the given path . If path is a LIST , the result will be LIST of types. json_valid(json) Return whether json is valid JS...son(json) Parse and minify json . The JSONPointer syntax separates each field with a / . For example, to extract the first element of the array with key duck , you can do: SELECT json_extract ( '{"duck": [1, 2, 3]}' , '/duck/0' ); 1 The JSONPath syntax... - https://man.mtool.work/duckdb/1.3/data/json/json_functions.html
- Lambda Functions – DuckDB 9920
- 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
...Name Description list_transform(list, lambda(x)) Returns a list that is the result of applying the lambda function to each element of the input list. The return type is defined by the return type of the lambda function. See list_transform examples . lis...t_filter(list, lambda(x)) Constructs a list from those elements of the input list for which the lambda function returns true . DuckDB must be able to cast the lambda function's return t...r is the same as the input list's. See list_filter examples . list_reduce(list, lambda(x, y)[, initial_value]) Reduces all elements of the input list into a single scalar value by executing the lambda function on a running result and the next list eleme... - https://man.mtool.work/duckdb/1.3/sql/functions/lambda.html
- Indexing – DuckDB 9510
- 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
...or JSON objects , which use 0-based indexing. Examples The index origin is 1 for strings, lists, etc. SELECT list [ 1 ] AS element FROM ( SELECT [ 'first' , 'second' , 'third' ] AS list ); ┌─────────┐ │ element │ │ varchar │ ├─────────┤ │ first │ └─────...────┘ The index origin is 0 for JSON objects. SELECT json [ 1 ] AS element FROM ( SELECT '["first", "second", "third"]' :: JSON AS json ); ┌──────────┐ │ element │ │ json │ ├──────────┤ │ "second"...│ └──────────┘ 関連キーワード element first second json DuckDB based indexing objects index origin list third Documentation Dialect Copy Markdown Indexing uses... - https://man.mtool.work/duckdb/1.3/sql/dialect/indexing.html
- Array Type – DuckDB 9442
- 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
...extract and array_extract . Using the example in Defining an Array Field . The following queries for extracting the second element of an array are equivalent: SELECT id , arr [ 1 ] AS element FROM array_table ; SELECT id , list_extract ( arr , 1 ) AS el...ement FROM array_table ; SELECT id , array_extract ( arr , 1 ) AS element FROM array_table ; id element 10 1 20 4 Using the slicing notation returns a LIST : SELECT id , arr [ 1 : 2 ] AS elements...FROM array_table ; id elements 10 [1, 2] 20 [4, 5] Functions All LIST functions work with the ARRAY type. Additionally, several ARRAY -native functions... - https://man.mtool.work/duckdb/1.3/sql/data_types/array.html
- Complete API – DuckDB 8879
- 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
...db_vector vector ); void duckdb_vector_ensure_validity_writable ( duckdb_vector vector ); void duckdb_vector_assign_string_element ( duckdb_vector vector , idx_t index , const char * str ); void duckdb_vector_assign_string_element_len ( duckdb_vector ve...ate : The date object, as obtained from a DUCKDB_TYPE_DATE column. Return Value The duckdb_date_struct with the decomposed elements. duckdb_to_date Re-compose a duckdb_date from year, month and date ( duckdb_date_struct ). Syntax duckdb_date duckdb_to_d...te_struct date ); Parameters date : The year, month and date stored in a duckdb_date_struct . Return Value The duckdb_date element. duckdb_is_finite_date Test a duckdb_date to see if it is a finite value. Syntax bool duckdb_is_finite_date ( duckdb_date... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Vectors – DuckDB 8879
- 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
...primary array at that index is undefined (and can be uninitialized). The validity mask is a bitmask consisting of uint64_t elements. For every 64 values in the vector, one uint64_t element exists (rounded up). The validity mask has its bit set to 1 if t...method on the struct). However , the struct vector itself does have a validity mask. The reason for this is that the child elements of a struct can be NULL , but the struct itself can also be NULL . Lists Lists are nested types that contain a single chi...db_vector vector ); void duckdb_vector_ensure_validity_writable ( duckdb_vector vector ); void duckdb_vector_assign_string_element ( duckdb_vector vector , idx_t index , const char * str ); void duckdb_vector_assign_string_element_len ( duckdb_vector ve... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- Map Functions – DuckDB 8742
- 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
...Markdown Map Functions 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...on Return the size of the map (or the number of entries in the map). Example cardinality(map([4, 2], ['a', 'b'])) Result 2 element_at(map, key) Description Return the value for a given key as a list, or an empty list if the key is not contained in the m...type of the key provided in the second parameter must 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 c... - https://man.mtool.work/duckdb/1.3/sql/functions/map.html
- Types – DuckDB 8605
- 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
...ate : The date object, as obtained from a DUCKDB_TYPE_DATE column. Return Value The duckdb_date_struct with the decomposed elements. duckdb_to_date Re-compose a duckdb_date from year, month and date ( duckdb_date_struct ). Syntax duckdb_date duckdb_to_d...te_struct date ); Parameters date : The year, month and date stored in a duckdb_date_struct . Return Value The duckdb_date element. duckdb_is_finite_date Test a duckdb_date to see if it is a finite value. Syntax bool duckdb_is_finite_date ( duckdb_date...ime : The time object, as obtained from a DUCKDB_TYPE_TIME column. Return Value The duckdb_time_struct with the decomposed elements. duckdb_create_time_tz Create a duckdb_time_tz object from micros and a timezone offset. Syntax duckdb_time_tz duckdb_cre... - https://man.mtool.work/duckdb/1.3/clients/c/types.html
- Utility Functions – DuckDB 7427
- 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
...fnull(expr, other) A two-argument version of coalesce. is_histogram_other_bin(arg) Returns true when arg is the "catch-all element" of its datatype for the purpose of the histogram_exact function, which is equal to the "right-most boundary" of its datat...L, 'default_string') Result default_string is_histogram_other_bin(arg) Description Returns true when arg is the "catch-all element" of its datatype for the purpose of the histogram_exact function, which is equal to the "right-most boundary" of its datat... - https://man.mtool.work/duckdb/1.3/sql/functions/utility.html
DuckDB 1.3 Documentation / man.mtool.work