Horton

Re: PostgreSQL 18 GA press release draft

Jeff Davis <pgsql@j-davis.com>

View thread
From: Jeff Davis <pgsql@j-davis.com>
To: "Jonathan S. Katz" <jkatz@postgresql.org>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-09-14T17:08:49Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add modern SHA-2 based password hashes to pgcrypto.

  2. Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate

  3. Allow usage of match_orclause_to_indexcol() for joins

On Sun, 2025-09-14 at 09:41 -0400, Jonathan S. Katz wrote:
> I went with breaking this up into two sentences:
> 
> This release adds the 
> [`PG_UNICODE_FAST`](
> https://www.postgresql.org/docs/18/collation.html#COLLATION-MANAGING-
> STANDARD), 
> which provides full Unicode semantics for case transformations while 
> helping to accelerate many comparisons. This includes the `upper` and
> `lower` string comparison functions and the new 
> [`casefold`](
> https://www.postgresql.org/docs/18/functions-string.html#FUNCTIONS-
> STRING-OTHER) 
> function for case-insensitive comparisons.

Perfect, thank you.

Regards,
	Jeff Davis