org.datanucleus.store.rdbms.sql.method

Class StringIndexOf5Method

java.lang.Object

org.datanucleus.store.rdbms.sql.method.AbstractSQLMethod

org.datanucleus.store.rdbms.sql.method.StringIndexOf5Method

All Implemented Interfaces:

SQLMethod

public class StringIndexOf5Method
extends AbstractSQLMethod

Method for evaluating {strExpr1}.indexOf(strExpr2[,pos]) for PostgreSQL. Note that this will not work if there is subsequent addition/subtraction of this value, but PostgreSQL doesn't have a simple function for this. If pos is not specified then returns a NumericExpression equating to

STRPOS(strExpr1, strExpr2, numExpr1+1)-1

otherwise returns

 CASE WHEN (STRPOS(SUBSTR(STR_FIELD, START_POS)) > 0) 
   THEN (STRPOS(SUBSTR(STR_FIELD, START_POS), STR) -1 + START_POS)
 ELSE
   -1
 

Field Summary

Fields inherited from class org.datanucleus.store.rdbms.sql.method.AbstractSQLMethod

clr, exprFactory, stmt

Constructor Summary

Constructors

Constructor and Description
StringIndexOf5Method()

Method Summary

Modifier and Type	Method and Description
SQLExpression	getExpression(SQLExpression expr, List<SQLExpression> args) Return the expression for this SQL function.

Methods inherited from class org.datanucleus.store.rdbms.sql.method.AbstractSQLMethod

getMappingForClass, setStatement

Methods inherited from class java.lang.Object

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

Constructor Detail

StringIndexOf5Method

public StringIndexOf5Method()

Method Detail

getExpression

public SQLExpression getExpression(SQLExpression expr,
                                   List<SQLExpression> args)

Description copied from interface: SQLMethod

Return the expression for this SQL function.

Parameters:

expr - The expression that it is invoked on

args - Arguments passed in

Returns:

The SQL expression using the SQL function