Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement array_aggregate function #7213

Open
izveigor opened this issue Aug 7, 2023 · 0 comments
Open

Implement array_aggregate function #7213

izveigor opened this issue Aug 7, 2023 · 0 comments
Labels
enhancement New feature or request

Comments

@izveigor
Copy link
Contributor

izveigor commented Aug 7, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
1 participant