Christophe Pettus <xof@thebuild.com> writes:
>> On Aug 1, 2024, at 09:25, PG Bug reporting form <noreply@postgresql.org> wrote:
>> I am migrating for
>> other database, bacause of the dificulty to get a similar resource to
>> substitute the "FIRST" in PostgreSQL and I hope you can recognize this bad
>> error and implement something to suppply this lack. Good bye!
> It's trivial to implement in PostgreSQL:
> https://wiki.postgresql.org/wiki/First/last_(aggregate)
The built-in (since v16) "any_value()" aggregate is actually just like
what that page shows for "first()". The name is chosen to reflect the
fact that the aggregate itself isn't promising anything: you have to
use it in the correct way to get useful behavior.
regards, tom lane
