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.