tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "DaeMyung Kang (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (TAJO-343) Implement locate function
Date Sat, 07 Dec 2013 15:01:42 GMT

    [ https://issues.apache.org/jira/browse/TAJO-343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13842241#comment-13842241
] 

DaeMyung Kang commented on TAJO-343:
------------------------------------

[~deepblue.kblee]

Please make patch using git diff with --no-prefix option

it is not default patch type :)

> Implement locate function
> -------------------------
>
>                 Key: TAJO-343
>                 URL: https://issues.apache.org/jira/browse/TAJO-343
>             Project: Tajo
>          Issue Type: New Feature
>          Components: operator/function/udf
>            Reporter: Hyunsik Choi
>            Assignee: KyoungBok Lee
>            Priority: Minor
>             Fix For: 0.8-incubating
>
>         Attachments: TAJO-343.patch
>
>
> h3. Function definition
> {code}
> int4 locate(string text, substr text, [, pos])
> {code}
> h3. Description
> Returns the position of the first occurance of substr in str after position pos
>  * The result is one-based index.
>  * If string or substr is null, the result should be null.
>  * *pos* is one-based index.
>  * *pos* cannot be a negative integer.
>  * If 0 is given to *pos*, the function considers that pos is 1.
>  * If there is no pos, the function considers that pos is 1.
>  * If there is no matched substring, the result should be 0.
> h3. Example
> {code}
> SELECT locate('foobarbar', 'bar',5);
> -> 7
> {code}



--
This message was sent by Atlassian JIRA
(v6.1#6144)

Mime
View raw message