From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christophe Pettus <xof@thebuild.com>
cc: iuritomazini.dev@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18563: Where is tha "FIRST" aggregate function??
In-reply-to: <8E8D05C8-329E-4D3E-9C31-25A6EB339C4D@thebuild.com>
References: <18563-bed7c7e283cc81b5@postgresql.org>
 <8E8D05C8-329E-4D3E-9C31-25A6EB339C4D@thebuild.com>
Comments: In-reply-to Christophe Pettus <xof@thebuild.com>
	message dated "Thu, 01 Aug 2024 10:38:29 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3781616.1722540209.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 01 Aug 2024 15:23:29 -0400
Message-ID: <3781617.1722540209@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3781617.1722540209%40sss.pgh.pa.us>
Precedence: bulk

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