Implement array_pop_back function #6997
Description
Is your feature request related to a problem or challenge?
Summary
| Characteristic | Description |
|---|---|
| Function name: | array_pop_back |
| Aliases: | list_pop_back |
| Original function?: | No |
| Function Description: | ClickHouse: Removes the last item from the array. DuckDB: Returns the list without the last element. |
| Sources: | Concept DuckDB ClickHouse |
Examples:
D select array_pop_back([1, 2, 3, 4]);
┌─────────────────────────────────────────────┐
│ array_pop_back(main.list_value(1, 2, 3, 4)) │
│ int32[] │
├─────────────────────────────────────────────┤
│ [1, 2, 3] │
└─────────────────────────────────────────────┘
D select array_pop_back([[1, 2], [3, 4], [4, 2]]);
┌──────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ array_pop_back(main.list_value(main.list_value(1, 2), main.list_value(3, 4), main.list_value(4, 2))) │
│ int32[][] │
├──────────────────────────────────────────────────────────────────────────────────────────────────────┤
│ [[1, 2], [3, 4]] │
└──────────────────────────────────────────────────────────────────────────────────────────────────────┘
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response