v.22.2Improvement
REGEXP_MATCHES and REGEXP_REPLACE Function Aliases for PostgreSQL Compatibility
REGEXP_MATCHESandREGEXP_REPLACEfunction aliases for compatibility with PostgreSQL. Close #30885. #34334 (李扬).
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 aliasesREGEXP_MATCHES and REGEXP_REPLACE in their SQL queries exactly as they would in PostgreSQL, without any additional configuration required.