New API for REGEXP_COUNT

[AbelAlexJohn]

Please extend the API to include a new scalar function REGEXP_COUNT

REGEXP_COUNT receives 3 arguments, the source string, regex pattern and optional start position which is defaulted at 1.

Example Queries

-- Returns number of occurrences of the letter 'e' in 'exasol'
SELECT REGEXP_COUNT('exasol', 'e') FROM dual; -- returns 1

-- Returns number of occurrences of the letter 'e' in 'exasol' starting from position 2
SELECT REGEXP_COUNT('exasol', 'e', 2) FROM dual; -- returns 0

-- Typical use in a table context
SELECT REGEXP_COUNT(column_name, '[0-9]' ) FROM my_table;

Capabilities

New capability

• FN_REGEXP_COUNT

[redcatbear]

Will take the request to PM. Please note that adding this to virtual schema common does not automatically make the feature available in any of the VS that depend on this.

[narmion]

@redcatbear Perhaps for clarification:
We implemented REGEXP_COUNT as introductory task for @AbelAlexJohn. Part of any new function is to inform you about the new function and to ask for a capability. It is up to you to schedule it. There is no time pressure. This is mainly for completeness :).