You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@mrql.apache.org by Apache Wiki <wi...@apache.org> on 2016/10/25 15:01:03 UTC

[Mrql Wiki] Trivial Update of "SystemFunctions" by LeonidasFegaras

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Mrql Wiki" for change notification.

The "SystemFunctions" page has been changed by LeonidasFegaras:
https://wiki.apache.org/mrql/SystemFunctions?action=diff&rev1=1&rev2=2

  In the following system functions, {{{a}}} stands for any type, numeric stands for any numerical value, and all functions on bags can be applied to other collections types too.
  
  
- || '''Name''' || '''Input''' || '''Output''' || Description''' ||
+ || '''Name''' || '''Input''' || '''Output''' || '''Description''' ||
  || = || ({{{a}}},{{{a}}}) || boolean || equality (infix) ||
  || <> || ({{{a}}},{{{a}}}) || boolean || not equal (infix) ||
  || + || (string,string) || string || string concatenation (infix) ||
@@ -34, +34 @@

  || contains || (string,string) || boolean || true if the first string contains the second string ||
  || length || string || int || string size ||
  || substring || (string,int,int) || string || substring from beginIndex to endIndex ||
+ || split || (string,string) || string || Splits this string around matches of the given regular expression ||
+ || trim || string || string ||  Returns a copy of the string, with leading and trailing whitespace omitted ||
+ || replace || (string,string,string) || string || Replaces each substring of this string that matches the literal target sequence with the specified literal replacement sequence ||
+ || replaceAll || (string,string,string) || string || Replaces each substring of this string that matches the given regular expression with the given replacement ||
+ || replaceFirst || (string,string,string) || string || Replaces the first substring of this string that matches the given regular expression with the given replacement ||
+ || startsWith || (string,string) || boolean || Tests if this string starts with the specified prefix ||
+ || toLowerCase || string || string || Converts all of the characters in this String to lower case ||
+ || toUpperCase || string || string || Converts all of the characters in this String to upper case ||
  || count || bag({{{a}}}) || long || the number of elements in the bag ||
  || sum || bag(numeric) || numeric || sum of all values ||
  || max || bag(numeric) || numeric || maximum of all values ||