Interface | Description |
---|---|
AggregateFunction |
An aggregate function, which evalutes a collection of
Row s. |
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
ConcreteFunction implementation. |
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
boolean that
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 integer representing the
length of the input string . |
LessThanFunction | |
LessThanOrEqualFunction | |
LikeToRegexpFunction | |
Log10Function | |
LowerFunction |
LOWER(string): returns a
string containing 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
string representing the upper
case version of the input string . |
Function
implementations.