You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Seungun Choe (JIRA)" <ji...@apache.org> on 2014/04/24 03:37:19 UTC
[jira] [Commented] (TAJO-740) Implements function 'to_number'
[ https://issues.apache.org/jira/browse/TAJO-740?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13979183#comment-13979183 ]
Seungun Choe commented on TAJO-740:
-----------------------------------
https://reviews.apache.org/r/20644/
Please review my patch.
> Implements function 'to_number'
> -------------------------------
>
> Key: TAJO-740
> URL: https://issues.apache.org/jira/browse/TAJO-740
> Project: Tajo
> Issue Type: New Feature
> Affects Versions: 0.8.0
> Reporter: Seungun Choe
> Assignee: Seungun Choe
> Priority: Minor
> Attachments: TAJO-740.patch
>
>
> {code}
> to_number(text, text) / convert string to numeric / to_number('12,454.8-', '99G999D9S')
> to_number(text, text) / convert string to numeric / to_number('1-2,454.8', '99G999D9S')
> Results (Both) : -12454.8
> {code}
> This function follows postgresql rules.
--
This message was sent by Atlassian JIRA
(v6.2#6252)