REGEXP_SUBSTR

​

Syntax

​

Scalar

regexp_substr(value, pattern)

​

Arguments

​

Returns

• Type: STRING
• Possible values: The first full match (capture group zero).
• NULL behavior: Returns NULL for NULL value/pattern or when there is no match.

​

Properties

​

Examples

​

Typical behavior

SELECT regexp_substr('abc123def', '[0-9]+') AS "value", regexp_substr('abc', '[0-9]+') AS no_match;

​

Return the first matching word

SELECT regexp_substr('12 red 34 blue', '[a-z]+') AS first_word;

​

Limitations

• Invalid regular expressions raise an execution error.