regexp_count
function regexp_count(varchar, joniregexp) returns bigint
regexp_extract
SELECT REGEXP_EXTRACT('email_address@gmail.com', '@(.*?)\.' -- value 'gmail'
function regexp_extract(varchar, joniregexp) returns varchar function regexp_extract(varchar, joniregexp, bigint) returns varchar
regexp_extract_all
function regexp_extract_all(varchar, joniregexp) returns array<varchar> function regexp_extract_all(varchar, joniregexp, bigint) returns array<varchar>
regexp_like
SELECT REGEXP_like('email_address@gmail.com', '.*@.*\..*') AS is_valid_email -- value 'TRUE'
function regexp_like(varchar, joniregexp) returns boolean
regexp_position
function regexp_position(varchar, joniregexp) returns bigint function regexp_position(varchar, joniregexp, bigint) returns bigint function regexp_position(varchar, joniregexp, bigint, bigint) returns bigint
regexp_replace
SELECT REGEXP_REPLACE('text foo another text', 'foo', 'bar') -- value 'text bar another text'
function regexp_replace(varchar, joniregexp, function(array<varchar>, varchar)) returns varchar
regexp_split
function regexp_split(varchar, joniregexp) returns array<varchar>