v.22.2Improvement

REGEXP_MATCHES and REGEXP_REPLACE Function Aliases for PostgreSQL Compatibility

REGEXP_MATCHES and REGEXP_REPLACE function aliases for compatibility with PostgreSQL. Close #30885. #34334 (李扬).
Added REGEXP_MATCHES and REGEXP_REPLACE function aliases to improve compatibility with PostgreSQL.

Why it matters

This feature enables users migrating from PostgreSQL to ClickHouse or working with both systems to use familiar regular expression function names, simplifying query adaptation and improving cross-database compatibility.

How to use it

Users can replace existing ClickHouse functions with the aliases REGEXP_MATCHES and REGEXP_REPLACE in their SQL queries exactly as they would in PostgreSQL, without any additional configuration required.