Package org.axiondb.functions

Function implementations.

See:
Description

Interface Summary

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 Summary

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 .

Package org.axiondb.functions Description

Function implementations.