Spanner PostgreSQL dialect adds ILIKE and NOT ILIKE
UpdateVerifiedAdded Sep 22, 2026
PostgreSQL-dialect databases in Spanner now support the ILIKE and NOT ILIKE operators and the pg.ilike and pg.not_ilike functions for case-insensitive pattern matching.
Topics: Postgres
Summaries of vendors' own notes. Product names and logos belong to their owners; logos via logo.dev.
More Spanner releases
Every Spanner release| Date | Release | Type |
|---|---|---|
| Sep 2 | Spanner PostgreSQL dialect supports the TABLESAMPLE operator Update | Update |
| Aug 28 | Spanner supports expression indexes on scalar expressions Update | Update |
| Sep 11 | Spanner Graph adds semantic options and key uniqueness validation Update | Update |
| Sep 17 | Spanner queues are generally available (GA) GA | GA |
| Sep 18 | Spanner adds automatic parameterization of SQL query literals Update | Update |
| Aug 11 | Spanner applies the 80,000 mutation limit per DML statement Update | Update |
| Aug 10 | Spanner dynamic channel pooling for Go and Java clients is GA GA | GA |
| Jul 28 | Spanner supports creating tables without defining primary keys Update | Update |
