[TAJO-342] Implement strpos(string, substring) function

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Function/UDF
• Assignee: Hyoungjun Kim
• Reporter: Hyunsik Choi
• Created: 29/Nov/13 09:34
• Updated: 02/Dec/13 07:20
• Resolved: 02/Dec/13 04:23

Description

Function Definition

int strpos(string text, substring text)

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.

Example.

hyunsik=> select strpos('tajo','jo');
 strpos 
--------
      3
(1 row)