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
AggregateBigDecimalFunction
AndFunction
ArithmeticFunction
AsciiFunction
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.
BaseBooleanBranchFunction
BaseFunction	An abstract base ConcreteFunctionimplementation.
BitAndFunction
BitOrFunction
CastAsFunction	ANSI style Cast As Function function : CAST( {id|expr} AS type)
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.
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, timestamp)
DateToCharFunction	Syntax: DateToChar( date-expr, 'format-string' )
DifferenceFunction
DivideFunction
EqualFunction
ExistsFunction
FunctionIdentifier	A Selectable representing an unresolved Function.
GreaterThanFunction
GreaterThanOrEqualFunction
IfThenFunction	IFTHEN(condition value): returns value if condition evalates to true; else, it returns null.
InFunction
InStringFunction
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 string containing the lower case version of the input string.
LPadFunction
LTrimFunction
MatchesFunction	MATCHES(string, string): returns a boolean that indicates whether first string matches the regular expression represented by the second string
MaxFunction
MinFunction
ModFunction
MultiplyFunction
NotEqualFunction
NotExistsFunction
NotFunction
NotInFunction
NowFunction
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
SubstringFunction	Syntax: SUBSTRING(str, m [,n]) -- m is one(1) based index.)
SubtractFunction
SumFunction
TruncateFunction
UpperFunction	UPPER(string): returns a string representing the upper case version of the input string.

Package org.axiondb.functions Description

Function implementations.