search

Health-Union / dbt-xdb

Cross-database support for dbt
Apache License 2.0
9 stars 5 forks source link

regexp_substr / regexp_replace #10

Open norton120 opened 4 years ago

norton120 commented 4 years ago

valid in snowflake, seems like it needs to be “regexp_replace” in postgres

antoniolofiego commented 3 years ago

Not entirely sure if this is still a concern. There are no regexp_substr occurrences in the codebase, even though Snowflake has an Oracle-like regexp_substr.

Postgres does indeed have a regexp_replace function, as correctly used in /macros/regexp.sql. https://www.postgresql.org/docs/9.4/functions-string.html