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

public final Class TrimFunction

extends Function1_2
Class Inheritance
Imports
org.h2.engine.SessionLocal, org.h2.expression.Expression, .TypedValueExpression, org.h2.util.StringUtils, org.h2.value.TypeInfo, .Value, .ValueVarchar
A TRIM, LTRIM, RTRIM, or BTRIM function.

Field Summary

Modifier and TypeField and Description
private int
flags

public static final int
LEADING

The LEADING flag.

public static final int
MULTI_CHARACTER

The multi-character flag.

public static final int
TRAILING

The TRAILING flag.

Constructor Summary

AccessConstructor and Description
public
TrimFunction(Expression from, Expression space, int flags)

Method Summary

Modifier and TypeMethod and Description
public String
getName()

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

Get the name.

public StringBuilder
getUnenclosedSQL(StringBuilder
string builder
builder, int
formatting flags
sqlFlags)

Overrides org.h2.expression.function.Function1_2.getUnenclosedSQL.

Get the SQL statement of this expression.

public Value
getValue(SessionLocal
the session
session, Value
the value of first argument
v1, Value
the value of second argument, or null
v2)

Overrides org.h2.expression.function.Function1_2.getValue.

Returns the value of this function.

public Expression
optimize(SessionLocal
the session
session)

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

Try to optimize the expression.

Inherited from org.h2.expression.function.Function1_2:
getValue

Field Detail

flagsback to summary
private int flags
LEADINGback to summary
public static final int LEADING

The LEADING flag.

MULTI_CHARACTERback to summary
public static final int MULTI_CHARACTER

The multi-character flag.

TRAILINGback to summary
public static final int TRAILING

The TRAILING flag.

Constructor Detail

TrimFunctionback to summary
public TrimFunction(Expression from, Expression space, int flags)

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
getUnenclosedSQLback to summary
public StringBuilder getUnenclosedSQL(StringBuilder builder, int sqlFlags)

Overrides org.h2.expression.function.Function1_2.getUnenclosedSQL.

Doc from org.h2.expression.Expression.getUnenclosedSQL.

Get the SQL statement of this expression. This may not always be the original SQL statement, especially after optimization. Enclosing '(' and ')' are never appended.

Parameters
builder:StringBuilder

string builder

sqlFlags:int

formatting flags

Returns:StringBuilder

the specified string builder

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

Overrides org.h2.expression.function.Function1_2.getValue.

Doc from org.h2.expression.function.Function1_2.getValue.

Returns the value of this function.

Parameters
session:SessionLocal

the session

v1:Value

the value of first argument

v2:Value

the value of second argument, or null

Returns:Value

the resulting value

Annotations
@Override
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