jiaan.geng created SPARK-30796:
----------------------------------

             Summary: Add parameter position for REGEXP_REPLACE
                 Key: SPARK-30796
                 URL: https://issues.apache.org/jira/browse/SPARK-30796
             Project: Spark
          Issue Type: New Feature
          Components: SQL
    Affects Versions: 3.1.0
            Reporter: jiaan.geng


 

postgresql

{{format: regexp_replace}}(_{{source}}_, _{{pattern}}_, _{{replacement}}_ [, 
_{{flags}}_ ]).

reference: [https://www.postgresql.org/docs/11/functions-matching.html]

vertica

REGEXP_REPLACE( _string_, _target_ [, _replacement_ [, _position_ [, 
_occurrence_ ... [, _regexp_modifiers_ ] ] ] ] )

reference: 
[https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/RegularExpressions/REGEXP_REPLACE.htm?zoom_highlight=regexp_replace]

oracle

[https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/REGEXP_REPLACE.html#GUID-EA80A33C-441A-4692-A959-273B5A224490]

redshift

https://docs.aws.amazon.com/redshift/latest/dg/REGEXP_REPLACE.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to