[TAJO-343] Implement locate function

• Type: New Feature
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Function/UDF
• Assignee: KyoungBok Lee
• Reporter: Hyunsik Choi
• Created: 29/Nov/13 09:45
• Updated: 08/Dec/13 04:27
• Resolved: 07/Dec/13 19:35

Description

Function definition

int4 locate(string text, substr text, [, pos])

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.

Example

SELECT locate('foobarbar', 'bar',5);
-> 7