spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Takeshi Yamamuro (Jira)" <j...@apache.org>
Subject [jira] [Updated] (SPARK-28077) ANSI SQL: OVERLAY function(T312)
Date Sun, 29 Dec 2019 00:23:00 GMT

     [ https://issues.apache.org/jira/browse/SPARK-28077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Takeshi Yamamuro updated SPARK-28077:
-------------------------------------
    Parent Issue: SPARK-30374  (was: SPARK-27764)

> ANSI SQL: OVERLAY function(T312)
> --------------------------------
>
>                 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
>            Assignee: jiaan.geng
>            Priority: Major
>             Fix For: 3.0.0
>
>
> ||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
(v8.3.4#803005)

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


Mime
View raw message