Re: PostgreSQL 19 Beta 1 release announcement draft - Mailing list pgsql-hackers

From Jonathan S. Katz
Subject Re: PostgreSQL 19 Beta 1 release announcement draft
Date
Msg-id a9d91900-f0c6-4cf3-86aa-eb43b45d97b1@postgresql.org
Whole thread
In response to Re: PostgreSQL 19 Beta 1 release announcement draft  (Florents Tselai <florents.tselai@gmail.com>)
Responses Re: PostgreSQL 19 Beta 1 release announcement draft
List 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@postgresql.org 
> <mailto:jkatz@postgresql.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

Attachment

pgsql-hackers by date:

Previous
From: Imran Zaheer
Date:
Subject: Re: BUG with accessing to temporary tables of other sessions still exists
Next
From: Jeff Davis
Date:
Subject: Re: Avoid orphaned objects dependencies, take 3