Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-889

Add trim() function matching ANSI SQL definition

    XMLWordPrintableJSON

    Details

      Description

      Add support for an ISO-SQL compliant trim() function, i.e. trim([leading | trailing | both] [characters] from string). Lack of this impacts users of BI tools migrating existing SQL from other systems.

      Reference: https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/String/TRIM.htm

      Part of the ANSI definition

      <trim function> ::=
        TRIM <left paren> <trim operands> <right paren>
      <trim operands> ::=
        [ [ <trim specification> ] [ <trim character> ] FROM ] <trim source>
      <trim source> ::=
        <character value expression>
      <trim specification> ::=
          LEADING
        | TRAILING
        | BOTH
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                jseidman_impala_e20b Jonathan Seidman
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated: