Results of 1 - 6 of about 6 for slice (0.006 sec.)
- List Functions – DuckDB 13088
- 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
...x] Bracket notation serves as an alias for list_extract . list[begin:end] Bracket notation with colon is an alias for list_slice . list[begin:end:step] list_slice in bracket notation with an added step feature. array_pop_back(list) Returns the list wi...erses the list. list_select(value_list, index_list) Returns a list based on the elements selected by the index_list . list_slice(list, begin, end, step) list_slice with added step feature. list_slice(list, begin, end) Extract a sublist using slice con...mple [4, 5, 6][3] Result 6 Alias list_extract list[begin:end] Description Bracket notation with colon is an alias for list_slice . Example [4, 5, 6][2:3] Result [5, 6] Alias list_slice list[begin:end:step] Description list_slice in bracket notation wi... - https://man.mtool.work/duckdb/1.3/sql/functions/list.html
- Text Functions – DuckDB 9231
- 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 Description string[index] Extracts a single character using a (1-based) index. string[begin:end] Extracts a string using slice conventions similar to Python. Missing begin or end arguments are interpreted as the beginning or end of the list respecti...cat(list1, list2) . array_extract(string, index) Extracts a single character from a string using a (1-based) index . array_slice(list, begin, end) Extracts a sublist or substring using slice conventions . Negative values are accepted. ascii(string) Re...a (1-based) index. Example 'DuckDB'[4] Result k Alias array_extract string[begin:end] Description Extracts a string using slice conventions similar to Python. Missing begin or end arguments are interpreted as the beginning or end of the list respecti... - https://man.mtool.work/duckdb/1.3/sql/functions/text.html
- Vectors – DuckDB 8481
- 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
...cution Format Pivot Sitemap Live Demo Documentation / Client APIs / C Copy Markdown Vectors Vectors represent a horizontal slice of a column. They hold a number of values of a specific type, similar to an array. Vectors are the core data representatio...( duckdb_vector vector , idx_t index ); duckdb_vector duckdb_array_vector_get_child ( duckdb_vector vector ); void duckdb_slice_vector ( duckdb_vector vector , duckdb_selection_vector selection , idx_t len ); void duckdb_vector_reference_value ( duck...uckdb_array_vector_get_child ( duckdb_vector vector ); Parameters vector : The vector Return Value The child vector duckdb_slice_vector Slice a vector with a selection vector. The max value in the selection vector must be less than the length of the v... - https://man.mtool.work/duckdb/1.3/clients/c/vector.html
- List Type – DuckDB 8280
- 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
...ions are provided as aliases for compatibility with systems that refer to lists as arrays. For example, the function array_slice . Example Result SELECT ['a', 'b', 'c'][3] 'c' SELECT ['a', 'b', 'c'][-1] 'c' SELECT ['a', 'b', 'c'][2 + 1] 'c' SELECT lis...T ['a', 'b', 'c'][1:2] ['a', 'b'] SELECT ['a', 'b', 'c'][:2] ['a', 'b'] SELECT ['a', 'b', 'c'][-2:] ['b', 'c'] SELECT list_slice(['a', 'b', 'c'], 2, 3) ['b', 'c'] Comparison and Ordering The LIST type can be compared using all the comparison operators... - https://man.mtool.work/duckdb/1.3/sql/data_types/list.html
- Complete API – DuckDB 7860
- 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
...( duckdb_vector vector , idx_t index ); duckdb_vector duckdb_array_vector_get_child ( duckdb_vector vector ); void duckdb_slice_vector ( duckdb_vector vector , duckdb_selection_vector selection , idx_t len ); void duckdb_vector_reference_value ( duck...uckdb_array_vector_get_child ( duckdb_vector vector ); Parameters vector : The vector Return Value The child vector duckdb_slice_vector Slice a vector with a selection vector. The max value in the selection vector must be less than the length of the v...ector The resulting vector happens to be a dictionary vector. Syntax void duckdb_slice_vector ( duckdb_vector vector , duckdb_selection_vector selection , idx_t len ); Parameters vector : The vector which is t... - https://man.mtool.work/duckdb/1.3/clients/c/api.html
- Data Chunks – DuckDB 7860
- 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
...ormat Pivot Sitemap Live Demo Documentation / Client APIs / C Copy Markdown Data Chunks Data chunks represent a horizontal slice of a table. They hold a number of vectors , that can each hold up to the VECTOR_SIZE rows. The vector size can be obtained... - https://man.mtool.work/duckdb/1.3/clients/c/data_chunk.html
PREV
1
NEXT
DuckDB 1.3 Documentation / man.mtool.work