-
Notifications
You must be signed in to change notification settings - Fork 1.7k
Open
Labels
enhancementNew feature or requestNew feature or request
Description
Is your feature request related to a problem or challenge?
Summary
| Characteristic | Description |
|---|---|
| Function name: | array_aggregate |
| Aliases: | list_aggregate, array_aggr, list_aggr |
| Original function?: | No |
| Function Description: | DuckDB: Executes the aggregate function name on the elements of list. See the List Aggregates section for more details. |
| Sources: | Concept DuckDB |
Examples:
D select list_aggregate([1, 2, NULL], 'min');
┌────────────────────────────────────────────────────┐
│ list_aggregate(main.list_value(1, 2, NULL), 'min') │
│ int32 │
├────────────────────────────────────────────────────┤
│ 1 │
└────────────────────────────────────────────────────┘
D select list_aggregate([1, 3, NULL, 5], 'sum');
┌───────────────────────────────────────────────────────┐
│ list_aggregate(main.list_value(1, 3, NULL, 5), 'sum') │
│ int128 │
├───────────────────────────────────────────────────────┤
│ 9 │
└───────────────────────────────────────────────────────┘
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response
Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or request