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.