Top Description Fields Constructors Methods
org.h2.expression.function

public final Class StringFunction

extends FunctionN
Class Inheritance
Imports
org.h2.engine.Mode.ModeEnum, .SessionLocal, org.h2.expression.Expression, .TypedValueExpression, org.h2.message.DbException, org.h2.util.StringUtils, org.h2.value.TypeInfo, .Value, .ValueInteger, .ValueNull, .ValueVarchar
An string function with multiple arguments.

Field Summary

Modifier and TypeField and Description
private final int
function

public static final int
INSERT

INSERT() (non-standard).

public static final int
LOCATE

LOCATE() (non-standard).

public static final int
LPAD

LPAD().

private static final String[]
NAMES

public static final int
REPLACE

REPLACE() (non-standard).

public static final int
RPAD

RPAD().

public static final int
TRANSLATE

TRANSLATE() (non-standard).

Constructor Summary

AccessConstructor and Description
public
StringFunction(Expression arg1, Expression arg2, Expression arg3, int function)

public
StringFunction(Expression arg1, Expression arg2, Expression arg3, Expression arg4, int function)

public
StringFunction(Expression[] args, int function)

Method Summary

Modifier and TypeMethod and Description
public String
getName()

Implements org.h2.expression.function.NamedExpression.getName.

Get the name.

public Value
getValue(SessionLocal
the session
session)

Overrides org.h2.expression.function.FunctionN.getValue.

Return the resulting value for the current row.

private static String
insert(String s1, int start, int length, String s2)

private static int
locate(String search, String s, int start)

public Expression
optimize(SessionLocal
the session
session)

Implements abstract org.h2.expression.Expression.optimize.

Try to optimize the expression.

private static String
translate(String original, String findChars, String replaceChars)

Inherited from org.h2.expression.function.FunctionN:
getUnenclosedSQLgetValue

Field Detail

functionback to summary
private final int function
INSERTback to summary
public static final int INSERT

INSERT() (non-standard).

LOCATEback to summary
public static final int LOCATE

LOCATE() (non-standard).

LPADback to summary
public static final int LPAD

LPAD().

NAMESback to summary
private static final String[] NAMES
REPLACEback to summary
public static final int REPLACE

REPLACE() (non-standard).

RPADback to summary
public static final int RPAD

RPAD().

TRANSLATEback to summary
public static final int TRANSLATE

TRANSLATE() (non-standard).

Constructor Detail

StringFunctionback to summary
public StringFunction(Expression arg1, Expression arg2, Expression arg3, int function)
StringFunctionback to summary
public StringFunction(Expression arg1, Expression arg2, Expression arg3, Expression arg4, int function)
StringFunctionback to summary
public StringFunction(Expression[] args, int function)

Method Detail

getNameback to summary
public String getName()

Implements org.h2.expression.function.NamedExpression.getName.

Doc from org.h2.expression.function.NamedExpression.getName.

Get the name.

Returns:String

the name in uppercase

Annotations
@Override
getValueback to summary
public Value getValue(SessionLocal session)

Overrides org.h2.expression.function.FunctionN.getValue.

Doc from org.h2.expression.Expression.getValue.

Return the resulting value for the current row.

Parameters
session:SessionLocal

the session

Returns:Value

the result

Annotations
@Override
insertback to summary
private static String insert(String s1, int start, int length, String s2)
locateback to summary
private static int locate(String search, String s, int start)
optimizeback to summary
public Expression optimize(SessionLocal session)

Implements abstract org.h2.expression.Expression.optimize.

Doc from org.h2.expression.Expression.optimize.

Try to optimize the expression.

Parameters
session:SessionLocal

the session

Returns:Expression

the optimized expression

Annotations
@Override
translateback to summary
private static String translate(String original, String findChars, String replaceChars)