com.gigaspaces.query.sql.functions

Class InStrSqlFunction

java.lang.Object

com.gigaspaces.query.sql.functions.SqlFunction

com.gigaspaces.query.sql.functions.InStrSqlFunction

public class InStrSqlFunction
extends SqlFunction

Built in string sql function to get the position of the first occurrence of a substring in a string.

Since:

11.0.0

Author:

Tamir Schwarz

Constructor Summary

Constructors

Constructor and Description
InStrSqlFunction()

Method Summary

Modifier and Type	Method and Description
Object	apply(SqlFunctionExecutionContext context) inStr is an SQL convention (Not Java's), in the sense that the first index is 1 and not 0.

Methods inherited from class com.gigaspaces.query.sql.functions.SqlFunction

assertNumberOfArguments, assertNumberOfArguments, fromSqlTypeName, isString, isWholeNumber

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

InStrSqlFunction

public InStrSqlFunction()

Method Detail

apply

public Object apply(SqlFunctionExecutionContext context)

inStr is an SQL convention (Not Java's), in the sense that the first index is 1 and not 0.

Specified by:

apply in class SqlFunction

Parameters:

context - contains two arguments of type string.

Returns:

the index of the first occurrence of context.getArgument(1) in context.getArgument(0). If not a substring, return value of 0.