Re: PostgreSQL 19 Beta 1 release announcement draft

[Jonathan S. Katz]

On 5/31/26 12:15 PM, Florents Tselai wrote:

On Fri, May 29, 2026 at 6:23 AM Jonathan S. Katz <jk...@postgresql.org <mailto:jk...@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:


I'd also add GROUP BY ALL in that paragraph as well.

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

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.

OpenPGP_signature.asc
Description: OpenPGP digital signature