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-342) Implement strpos(string, substring) function
Date Fri, 29 Nov 2013 09:35:35 GMT
Hyunsik Choi created TAJO-342:
---------------------------------

             Summary: Implement strpos(string, substring) function
                 Key: TAJO-342
                 URL: https://issues.apache.org/jira/browse/TAJO-342
             Project: Tajo
          Issue Type: New Feature
          Components: operator/function/udf
            Reporter: Hyunsik Choi
             Fix For: 0.8-incubating


h3. Function Definition
{code}
int strpos(string text, substring text)
{code}

h3. Description
This function finds the location of specified substring.
 * If string or substring is null, the result should be null.
 * If substring is '', the result should be 1.
 * If there is no matched substring, the result should be 0.
 * The result is one-based index.

h3. Example.
{code}
hyunsik=> select strpos('tajo','jo');
 strpos 
--------
      3
(1 row)
{code}



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

Mime
View raw message