[
https://issues.apache.org/jira/browse/TRAFODION-2403?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15771270#comment-15771270
]
ASF GitHub Bot commented on TRAFODION-2403:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/883#discussion_r93706480
--- Diff:
docs/sql_reference/src/asciidoc/_chapters/sql_language_elements.adoc ---
@@ -3352,6 +3353,59 @@ The escape character indicates that the underscore
in 'FLOPPY_DISK' is
part of the string to search for, not a wild-card character.
<<<
+[[regexp_predicate]]
+=== REGEXP Predicate
+
+Performs a pattern match of a string expression against a pattern .
+The pattern can be an extended regular expression.
+Returns 1 if expression matches pattern; otherwise it returns 0.
+If either expression or pattern is NULL, the result is NULL.
+
+[[regexp_syntax]]
+==== Syntax
+```
+match-value [NOT] REGEXP regular-expression
+```
+
+* `_match-value_`
++
+is a character value expression that specifies a set of strings to
+search for that match the _pattern_.
+
+* `_pattern_`
++
+is a character value expression that specifies a regular expression.
+Trafodion regular expressions follow POSIX regular expression rules.
+
+
+[[using_not]]
+===== Using NOT
+
+If you specify NOT, the predicate is true if the _pattern_ does not
--- End diff --
Should say _regular-expression_ here instead of _pattern_.
> update sql reference manual about REGEXP function
> -------------------------------------------------
>
> Key: TRAFODION-2403
> URL: https://issues.apache.org/jira/browse/TRAFODION-2403
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: liu ming
> Assignee: liu ming
>
> REGEXP was added, need document update for it
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
