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.stackexchange.com/a/324646/100880>
(https://dba.stackexchange.com/a/324646/100880)
GitHub: https://github.com/wulczer/first_last_agg
Reason: As a non-dba, I can’t install additional modules like first_last_agg
.
Thanks,
-Ben