Spanner Adds PostgreSQL-Dialect ILIKE and NOT ILIKE Operators
datagcpgaengineergcp-spanner
feature
Google Cloud Spanner now supports PostgreSQL-dialect `ILIKE` and `NOT ILIKE` database operators, including their `~~*` and `!~~*` syntax. This enhancement also extends to the `pg.ilike` and `pg.not_ilike` functions. The addition simplifies pattern matching for developers and improves compatibility for those migrating or building applications with PostgreSQL-like querying needs.
Features (1) ›
- Spanner
Spanner supports the following PostgreSQL-dialect database operators: ILIKE ( ~~* ) NOT ILIKE ( !~~* ) Spanner supports the following PostgreSQL-dialect database functions: pg.ilike pg.not_ilike For more information, see Pattern matching operators and Functions .
Read the original announcement →
https://docs.cloud.google.com/release-notes#September_03_2026
Related releases
- Google Cloud expands Data Cloud with real-time analytics, AI, and open tables Google Cloud Blog ·
- Spanner Adds TABLESAMPLE Operator for PostgreSQL-dialect Databases Google Cloud release notes ·
- Cloud Spanner Now Supports Secondary Indexes Based on Scalar Expressions Google Cloud release notes ·
- Google details BigQuery Graph's GA and cross-cloud analytics for AI agents Google Cloud Blog ·
- Google Cloud SDK 582.0.0 Introduces Breaking Changes and New Features Google Cloud release notes ·
- Assured Workloads enhances data residency controls and ITAR support Google Cloud release notes ·