Re: BUG #18563: Where is tha "FIRST" aggregate function??

Christophe Pettus <xof(at)thebuild(dot)com> writes:
>> On Aug 1, 2024, at 09:25, PG Bug reporting form <noreply(at)postgresql(dot)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