You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Hyunsik Choi (JIRA)" <ji...@apache.org> on 2013/11/29 10:45:36 UTC
[jira] [Updated] (TAJO-342) Implement strpos(string, substring)
function
[ https://issues.apache.org/jira/browse/TAJO-342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hyunsik Choi updated TAJO-342:
------------------------------
Priority: Minor (was: Major)
> 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
> Priority: Minor
> 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)