pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18563: Where is tha "FIRST" aggregate function??
3+ messages / 3 participants
[nested] [flat]
* BUG #18563: Where is tha "FIRST" aggregate function??
@ 2024-08-01 16:25 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2024-08-01 16:25 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: iuritomazini.dev@gmail.com
The following bug has been logged on the website:
Bug reference: 18563
Logged by: Iuri Tomazini
Email address: iuritomazini.dev@gmail.com
PostgreSQL version: 16.0
Operating system: pgAdmin 4
Description:
PostagrSQL do not have a "FIRST" aggraregate function and it is a huge
mistake. All other good database has this and some of them are automatic,
such as MySQL. Take a fast search and discover that this kind of topic is
commonly find in internet (example: stackoverflow site). 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!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18563: Where is tha "FIRST" aggregate function??
@ 2024-08-01 17:38 Christophe Pettus <xof@thebuild.com>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 3+ messages in thread
From: Christophe Pettus @ 2024-08-01 17:38 UTC (permalink / raw)
To: iuritomazini.dev@gmail.com; pgsql-bugs@lists.postgresql.org
> 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)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18563: Where is tha "FIRST" aggregate function??
@ 2024-08-01 19:23 Tom Lane <tgl@sss.pgh.pa.us>
parent: Christophe Pettus <xof@thebuild.com>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2024-08-01 19:23 UTC (permalink / raw)
To: Christophe Pettus <xof@thebuild.com>; +Cc: iuritomazini.dev@gmail.com; pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-01 19:23 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-01 16:25 BUG #18563: Where is tha "FIRST" aggregate function?? PG Bug reporting form <noreply@postgresql.org>
2024-08-01 17:38 ` Christophe Pettus <xof@thebuild.com>
2024-08-01 19:23 ` Tom Lane <tgl@sss.pgh.pa.us>
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