You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Zoram Thanga (JIRA)" <ji...@apache.org> on 2017/10/16 18:28:00 UTC

[jira] [Created] (IMPALA-6059) Enhance ltrim() and rtrim() functions to trim any set of characters

Zoram Thanga created IMPALA-6059:
------------------------------------

             Summary: Enhance ltrim() and rtrim() functions to trim any set of characters
                 Key: IMPALA-6059
                 URL: https://issues.apache.org/jira/browse/IMPALA-6059
             Project: IMPALA
          Issue Type: Improvement
          Components: Backend
    Affects Versions: Product Backlog
            Reporter: Zoram Thanga
            Assignee: Zoram Thanga
            Priority: Minor


Enhance the existing ltrim() and rtrim() string functions to accept an argument that specifies a set of characters to be trimmed from the target string. This is in line with how these functions are implemented in PostgreSQL[1], Vertica[2], etc.

The new function signatures will look like:

ltrim(string text [, characters text])
rtrim(string text [, characters text])

[1] https://www.postgresql.org/docs/9.1/static/functions-string.html
[2] http://bit.ly/2wTE52M



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)