[
https://issues.jboss.org/browse/TEIID-3491?page=com.atlassian.jira.plugin...
]
Tom Arnold commented on TEIID-3491:
-----------------------------------
Sent pull request. Implemented using Java's Pattern class, so anything valid for that
can be used. One difference from most other implementations is that back-references in the
replacement string are written like {{$1}} instead of {{\1}}.
http://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html
I implemented another variant which allows several flags to be set that modify how the
match is performed. The supported flags are:
* {{i}} - case insensitive match
* {{g}} - global match (aka replace-all)
* {{m}} - multiline match; changes {{^}} and {{$}} to match line-beginning and line-end
instead of source-beginning and source-end.
I did not attempt to implement any pushdown support for this but I can look into it if
there is interest.
Add support for REGEXP_REPLACE
------------------------------
Key: TEIID-3491
URL:
https://issues.jboss.org/browse/TEIID-3491
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Reporter: Tom Arnold
Assignee: Steven Hawkins
Add support for REGEXP_REPLACE function like in Postgres.
http://www.postgresql.org/docs/9.3/static/functions-string.html
Pushdown version might be tricky.
* MySQL - No support.
* Postgres - Good.
* Oracle - Good, but "g" flag to replace all matches is set by positional
params instead.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)