| 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
| 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 |