| Interface | Description |
|---|---|
| AggregateFunction |
An aggregate function, which evalutes a collection of
Rows. |
| ConcreteFunction |
An executable
Function, as opposed to a FunctionIdentifier. |
| ScalarFunction |
A
ConcreteFunction that evaluates a single
Row. |
| Class | Description |
|---|---|
| ABSFunction | |
| AddFunction | |
| AndFunction | |
| ArithmeticFunction | |
| AsciiFunction |
Returns the Integer value of the left most char of the String
|
| AverageFunction | |
| Base64DecodeFunction |
BASE64DECODE(string): returns a byte array representing the Base64 decoded
value of the given string .
|
| Base64EncodeFunction |
BASE64ENCODE(byte[]): returns a string representing the Base64 encoded
value of the given byte[] or Blob.
|
| BaseAggregateFunction | |
| BaseBooleanBranchFunction | |
| BaseFunction |
An abstract base
ConcreteFunctionimplementation. |
| BaseRegExpFunction | |
| BitAndFunction | |
| BitOrFunction | |
| CastAsFunction |
ANSI style CAST...AS Function function : CAST( {id|expr} AS type[(precision[,scale])] )
|
| CharFunction |
CHAR(number): returns the character
representing the unicode value number . |
| CharToDateFunction |
Syntax: CharToDate( date-string, 'format-literal' )
|
| CoalesceFunction |
COALESCE([value]+): returns the first non-null value in the
argument list. |
| ComparableAggregateFunction | |
| ComparisonFunction | |
| ConcatFunction |
CONCAT(string [, string]*): concatenates one or more
strings. |
| ContainsFunction |
CONTAINS(string, string): returns a
booleanthat
indicates whether the second string is a substring of the first. |
| CountFunction |
COUNT: an aggregate function returning the number of rows. |
| DateAddFunction |
Syntax: DateAdd(interval_type, interval, timestamp)
|
| DateDiffFunction |
Syntax: DATEDIFF(interval_type, timestamp1, timestamp2)
|
| DatePartFunction |
Syntax: DatePart(date-part, date-src) or EXTRACT(date-part FROM date-src)
|
| DateToCharFunction |
Syntax: DateToChar( date-expr, 'format-string' )
|
| DifferenceFunction | |
| DivideFunction | |
| EqualFunction | |
| ExistsFunction | |
| FunctionIdentifier |
A
Selectable representing an unresolved Function. |
| GreaterThanFunction | |
| GreaterThanOrEqualFunction | |
| HexFunction | |
| IfThenFunction |
IFTHEN(condition value): returns value if condition
evalates to true; else, it returns null. |
| InFunction | |
| InStringFunction |
INSTR(str,substr): Returns the position of the first occurrence of substring substr in
string str.
|
| IsNotNullFunction | |
| IsNullFunction | |
| IsValidDateTimeFunction |
Function to test whether the given String expression is in the same format as the given
date format expression.
|
| LengthFunction |
Length(string): returns a
Type integerrepresenting the
length of the input string . |
| LessThanFunction | |
| LessThanOrEqualFunction | |
| LikeToRegexpFunction | |
| Log10Function | |
| LowerFunction |
LOWER(string): returns a
stringcontaining the lower
case version of the input string . |
| LPadFunction | |
| LTrimFunction | |
| MatchesFunction |
MATCHES(string, string): returns a
BooleanTypeboolean that
indicates whether first string matches the regular expression pattern
represented by the second string. |
| MaxFunction | |
| MinFunction | |
| ModFunction | |
| MultiplyFunction | |
| NotEqualFunction | |
| NotFunction | |
| NotInFunction | |
| NowFunction | |
| NullIfFunction |
The NULLIF function returns a null value if the arguments are equal, otherwise it
returns the value of the first argument.
|
| OrFunction | |
| ReplaceFunction | |
| RoundFunction | |
| RowNumFunction |
Returns an one-based index indicating the order in which a row was selected from a
table, join, etc.
|
| RPadFunction | |
| RTrimFunction | |
| SignFunction |
Returns an indicator of the sign of the given
double value. |
| SoundexFunction | |
| SoundsLikeFunction | |
| SpaceFunction |
Returns a string filled with a given number of spaces.
|
| SubstringFunction |
Syntax: SUBSTRING(str, m [,n]) -- m is one(1) based index.)
|
| SubtractFunction | |
| SumFunction | |
| TrimFunction |
TRIM ( [LEADING| TRAILING| BOTH] [ trim-character ] FROM ] trim-source) function
|
| TruncateFunction | |
| UpperFunction |
UPPER(string): returns a
stringrepresenting the upper
case version of the input string . |
Function implementations.