Re: PostgreSQL 19 Beta 1 release announcement draft

From: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
To: Florents Tselai <florents(dot)tselai(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL 19 Beta 1 release announcement draft
Date: 2026-06-03 17:50:15
Message-ID: a9d91900-f0c6-4cf3-86aa-eb43b45d97b1@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 5/31/26 12:15 PM, Florents Tselai wrote:
>
>
>
> On Fri, May 29, 2026 at 6:23 AM Jonathan S. Katz <jkatz(at)postgresql(dot)org
> <mailto:jkatz(at)postgresql(dot)org>> wrote:
>
> Hi,
>
> Attached is the draft of the PostgreSQL 19 Beta 1 release announcement.
> Please review for accuracy (e.g. are features described correctly?
> Did I
> miss a revert), recommendations on additions or glaring omissions,
> structure, etc.
>
> Please provide feedback no later than June 4, 2026 12:00 UTC (though
> preferably earlier!)
>
>
> I'd phrase the jsonpath part like this:
> This release extends string processing capabilities in jsonpath with the
> addition of lower(), upper(), initcap(), replace(), split_part(), and
> the trim() family of functions
>
> I'd also add GROUP BY ALL in that paragraph as well.

Thanks! I had missed GROUP BY ALL (I saw Jakub mention it too), that
looks very convenient. Proposing:

==
PostgreSQL 19 introduces the new `GROUP BY ALL` syntax, making it easy
to add all non-aggregate and non-window parameters as part of the
grouping. This release extends string processing capabilities in
jsonpath with the addition of `lower()`, `upper()`, `initcap()`,
`replace()`, `split_part()`, and the `trim()` family of functions.
===

Thanks,

Jonathan

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2026-06-03 18:08:13 Re: Avoid orphaned objects dependencies, take 3
Previous Message Imran Zaheer 2026-06-03 17:43:05 Re: BUG with accessing to temporary tables of other sessions still exists