From: Tom Lane <tgl@sss.pgh.pa.us>
To: Christophe Pettus <xof@thebuild.com>
Cc: iuritomazini.dev@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18563: Where is tha "FIRST" aggregate function??
Date: Thu, 01 Aug 2024 15:23:29 -0400
Message-ID: <3781617.1722540209@sss.pgh.pa.us> (raw)
In-Reply-To: <8E8D05C8-329E-4D3E-9C31-25A6EB339C4D@thebuild.com>
References: <18563-bed7c7e283cc81b5@postgresql.org>
<8E8D05C8-329E-4D3E-9C31-25A6EB339C4D@thebuild.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, xof@thebuild.com, iuritomazini.dev@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18563: Where is tha "FIRST" aggregate function??
In-Reply-To: <3781617.1722540209@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox