Re: PostgreSQL 18 GA press release draft

Nico Williams <nico@cryptonector.com>

From: Nico Williams <nico@cryptonector.com>

To: Jeff Davis <pgsql@j-davis.com>

Cc: "Jonathan S. Katz" <jkatz@postgresql.org>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>

Date: 2025-09-12T20:48:55Z

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 →

Add modern SHA-2 based password hashes to pgcrypto.
- 749a9e20c979 18.0 cited
Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate
- c0962a113d1f 18.0 cited
Allow usage of match_orclause_to_indexcol() for joins
- 627d63419e22 18.0 cited

On Fri, Sep 12, 2025 at 12:13:23PM -0700, Jeff Davis wrote:
> On Fri, 2025-09-12 at 13:21 -0500, Nico Williams wrote:
> > How does one do form-insensitive comparisons?
> 
> If you mean case insensitive matching, you can do:

I meant form-insensitive, as in comparing equivalent strings where one
might be using decomposed sequences and another pre-conposed sequences
(and either might be normalized or not at all).

Nico
--