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:35:35 UTC
[jira] [Created] (TAJO-342) Implement strpos(string, substring)
function
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)