[
https://issues.apache.org/jira/browse/TAJO-147?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hyunsik Choi updated TAJO-147:
------------------------------
Attachment: TAJO-147.patch
I've attached the trim string function.
In order to support SQL standard built-in string function, this patch improves
and refactors SQLParser.g. As a result, this implementation well follows SQL
standard as follows:
{code}
trim([leading | trailing | both] [characters] from string)
{code}
For PostgreSQL compatibility, It also adds btim, ltrim, and rtrim function and
some synonym function 'trim' of btrim.
Besides, this patch also removes the legacy license from NOTICE.txt and
LICENSE.txt for sql-frontend that was removed few month ago.
> Implement trim(text), ltrim(text), and rtrim(text) function
> -----------------------------------------------------------
>
> Key: TAJO-147
> URL: https://issues.apache.org/jira/browse/TAJO-147
> Project: Tajo
> Issue Type: Sub-task
> Components: operator/function/udf
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Priority: Minor
> Labels: newbie
> Fix For: 0.2-incubating
>
> Attachments: TAJO-147.patch
>
>
> We need to implement the below trim functions:
> * trim() function removes whitespaces in both sides
> * ltrim() function removes whitespaces in left side.
> * rtrim() function removes whitespaces in right side.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
