Back to feed
GCP·Spannerfeature·
AI Insights

Spanner supports the following PostgreSQL-dialect database operators:

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

More from Spanner

Spanner supports automatic parameterization of SQL query literals to improve query performance, reduce latency, and lower CPU costs.Sep 18, 2026Spanner queues are generally available (GA).Sep 17, 2026Spanner Graph supports the following enhancements for CREATE PROPERTY GRAPH:Sep 11, 2026Spanner supports using the TABLESAMPLE operator in PostgreSQL-dialect databases to select a random sample of a dataset.Sep 2, 2026