Search Postgresql Archives
Idea: Add first() and last() aggregate functions to the main release
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Idea: Add first() and last() aggregate functions to the main release
From
: Ben Clements <benhasgonewalking@xxxxxxxxx>
Date
: Sat, 11 Mar 2023 07:20:09 -0500
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
)
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Idea: Add first() and last() aggregate functions to the main release
From:
Erwin Brandstetter
Prev by Date:
Re: Practice advice for use of %type in declaring a subprogram's formal arguments
Next by Date:
ERROR: only immutable functions supported in continuous aggregate view
Previous by thread:
Practice advice for use of %type in declaring a subprogram's formal arguments
Next by thread:
Re: Idea: Add first() and last() aggregate functions to the main release
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]