Yuming Wang created SPARK-28077:
-----------------------------------
Summary: String Functions: Add support OVERLAY
Key: SPARK-28077
URL: https://issues.apache.org/jira/browse/SPARK-28077
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 3.0.0
Reporter: Yuming Wang
||Function||Return Type||Description||Example||Result||
|{{overlay(_string_ placing _string_ from }}{{int}}{{[for
{{int}}])}}|{{text}}|Replace substring|{{overlay('Txxxxas' placing 'hom' from 2
for 4)}}|{{Thomas}}|
For example:
{code:sql}
SELECT OVERLAY('abcdef' PLACING '45' FROM 4) AS "abc45f";
SELECT OVERLAY('yabadoo' PLACING 'daba' FROM 5) AS "yabadaba";
SELECT OVERLAY('yabadoo' PLACING 'daba' FROM 5 FOR 0) AS "yabadabadoo";
SELECT OVERLAY('babosa' PLACING 'ubb' FROM 2 FOR 4) AS "bubba";
{code}
https://www.postgresql.org/docs/11/functions-string.html
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
