tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hyunsik Choi (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TAJO-343) Implement locate function
Date Fri, 29 Nov 2013 09:45:35 GMT
Hyunsik Choi created TAJO-343:

             Summary: 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
            Priority: Minor
             Fix For: 0.8-incubating

h3. Function definition
int4 locate(string text, substr text, [, pos])

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
SELECT locate('foobarbar', 'bar',5);
-> 7

This message was sent by Atlassian JIRA

View raw message