regexp_replace()
Advertisements
Let us now check the regexp_replace(string text, pattern text, replacement text) function with the following query.
Query
default> select regexp_replace('abcdef', '(ˆab|ef$)', ‘–‘);
Result
The above query will generate the following result.
–cd–
The query replaces the substrings matched to a given regular expression pattern.
apache_tajo_string_functions.htm
Advertisements