Re: Idea: Add first() and last() aggregate functions to the main release

On Sat, 11 Mar 2023 at 23:38, Ben Clements wrote: > Idea/request for enhancement: > > Add the first() and last() aggregate functions to the main release (CREATE > EXTENSION first_last_agg). > > Use Case: PostgreSQL equivalent to Oracle's MAX(...) KEEP (DENSE_RANK > FIRST/LAST ORDER BY ...)

Idea: Add first() and last() aggregate functions to the main release

Idea/request for enhancement: Add the first() and last() aggregate functions to the main release (CREATE EXTENSION first_last_agg). Use Case: PostgreSQL equivalent to Oracle's MAX(...) KEEP (DENSE_RANK FIRST/LAST ORDER BY ...) (https://dba.stackexch