| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc --> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <title>SqlLibraryOperators (Apache Calcite calcite API)</title> |
| <link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style"> |
| <script type="text/javascript" src="../../../../../script.js"></script> |
| </head> |
| <body> |
| <script type="text/javascript"><!-- |
| try { |
| if (location.href.indexOf('is-external=true') == -1) { |
| parent.document.title="SqlLibraryOperators (Apache Calcite calcite API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| </script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a name="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> |
| <a name="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../../overview-summary.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../help-doc.html">Help</a></li> |
| </ul> |
| <div class="aboutLanguage"><b>Apache Calcite</b></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList"> |
| <li><a href="../../../../../org/apache/calcite/sql/fun/SqlLibrary.html" title="enum in org.apache.calcite.sql.fun"><span class="typeNameLink">Prev Class</span></a></li> |
| <li><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperatorTableFactory.html" title="class in org.apache.calcite.sql.fun"><span class="typeNameLink">Next Class</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../../index.html?org/apache/calcite/sql/fun/SqlLibraryOperators.html" target="_top">Frames</a></li> |
| <li><a href="SqlLibraryOperators.html" target="_top">No Frames</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../../allclasses-noframe.html">All Classes</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_top"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li>Constr | </li> |
| <li><a href="#methods.inherited.from.class.java.lang.Object">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li>Constr | </li> |
| <li>Method</li> |
| </ul> |
| </div> |
| <a name="skip.navbar.top"> |
| <!-- --> |
| </a></div> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <div class="header"> |
| <div class="subTitle">org.apache.calcite.sql.fun</div> |
| <h2 title="Class SqlLibraryOperators" class="title">Class SqlLibraryOperators</h2> |
| </div> |
| <div class="contentContainer"> |
| <ul class="inheritance"> |
| <li><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">java.lang.Object</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li>org.apache.calcite.sql.fun.SqlLibraryOperators</li> |
| </ul> |
| </li> |
| </ul> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <hr> |
| <br> |
| <pre>public abstract class <span class="typeNameLabel">SqlLibraryOperators</span> |
| extends <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></pre> |
| <div class="block">Defines functions and operators that are not part of standard SQL but |
| belong to one or more other dialects of SQL. |
| |
| <p>They are read by <a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperatorTableFactory.html" title="class in org.apache.calcite.sql.fun"><code>SqlLibraryOperatorTableFactory</code></a> into instances |
| of <a href="../../../../../org/apache/calcite/sql/SqlOperatorTable.html" title="interface in org.apache.calcite.sql"><code>SqlOperatorTable</code></a> that contain functions and operators for |
| particular libraries.</div> |
| </li> |
| </ul> |
| </div> |
| <div class="summary"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="field.summary"> |
| <!-- --> |
| </a> |
| <h3>Field Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation"> |
| <caption><span>Fields</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colLast" scope="col">Field and Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#CHR">CHR</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#COMPRESS">COMPRESS</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#CONCAT_FUNCTION">CONCAT_FUNCTION</a></span></code> |
| <div class="block">The "CONCAT(arg, ...)" function that concatenates strings.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#CONCAT2">CONCAT2</a></span></code> |
| <div class="block">The "CONCAT(arg0, arg1)" function that concatenates strings.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#CONVERT_TIMEZONE">CONVERT_TIMEZONE</a></span></code> |
| <div class="block">The "CONVERT_TIMEZONE(tz1, tz2, datetime)" function; |
| converts the timezone of <code>datetime</code> from <code>tz1</code> to <code>tz2</code>.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#COSH">COSH</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#DATE">DATE</a></span></code> |
| <div class="block">The "DATE(string)" function, equivalent to "CAST(string AS DATE).</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#DATE_FROM_UNIX_DATE">DATE_FROM_UNIX_DATE</a></span></code> |
| <div class="block">The "DATE_FROM_UNIX_DATE(integer)" function; returns a DATE value |
| a given number of seconds after 1970-01-01.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#DAYNAME">DAYNAME</a></span></code> |
| <div class="block">The "DAYNAME(datetime)" function; returns the name of the day of the week, |
| in the current locale, of a TIMESTAMP or DATE argument.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#DECODE">DECODE</a></span></code> |
| <div class="block">The "DECODE(v, v1, result1, [v2, result2, ...], resultN)" function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#DIFFERENCE">DIFFERENCE</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#EXISTS_NODE">EXISTS_NODE</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#EXTRACT_VALUE">EXTRACT_VALUE</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#EXTRACT_XML">EXTRACT_XML</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#FROM_BASE64">FROM_BASE64</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#GREATEST">GREATEST</a></span></code> |
| <div class="block">The "GREATEST(value, value)" function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#INFIX_CAST">INFIX_CAST</a></span></code> |
| <div class="block">Infix "::" cast operator used by PostgreSQL, for example |
| <code>'100'::INTEGER</code>.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#JSON_DEPTH">JSON_DEPTH</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#JSON_KEYS">JSON_KEYS</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#JSON_LENGTH">JSON_LENGTH</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#JSON_PRETTY">JSON_PRETTY</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#JSON_REMOVE">JSON_REMOVE</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#JSON_STORAGE_SIZE">JSON_STORAGE_SIZE</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#JSON_TYPE">JSON_TYPE</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#LEAST">LEAST</a></span></code> |
| <div class="block">The "LEAST(value, value)" function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#LEFT">LEFT</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#LTRIM">LTRIM</a></span></code> |
| <div class="block">The "LTRIM(string)" function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#MD5">MD5</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#MONTHNAME">MONTHNAME</a></span></code> |
| <div class="block">The "MONTHNAME(datetime)" function; returns the name of the month, |
| in the current locale, of a TIMESTAMP or DATE argument.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#NVL">NVL</a></span></code> |
| <div class="block">The "NVL(value, value)" function.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#REGEXP_REPLACE">REGEXP_REPLACE</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#REPEAT">REPEAT</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#REVERSE">REVERSE</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#RIGHT">RIGHT</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#RTRIM">RTRIM</a></span></code> |
| <div class="block">The "RTRIM(string)" function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#SHA1">SHA1</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#SINH">SINH</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#SOUNDEX">SOUNDEX</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#SPACE">SPACE</a></span></code> </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#STRCMP">STRCMP</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#SUBSTR">SUBSTR</a></span></code> |
| <div class="block">Oracle's "SUBSTR(string, position [, substringLength ])" function.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#TANH">TANH</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#TIMESTAMP_MICROS">TIMESTAMP_MICROS</a></span></code> |
| <div class="block">The "TIMESTAMP_MICROS(bigint)" function; returns a TIMESTAMP value |
| a given number of micro-seconds after 1970-01-01 00:00:00.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#TIMESTAMP_MILLIS">TIMESTAMP_MILLIS</a></span></code> |
| <div class="block">The "TIMESTAMP_MILLIS(bigint)" function; returns a TIMESTAMP value |
| a given number of milliseconds after 1970-01-01 00:00:00.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#TIMESTAMP_SECONDS">TIMESTAMP_SECONDS</a></span></code> |
| <div class="block">The "TIMESTAMP_SECONDS(bigint)" function; returns a TIMESTAMP value |
| a given number of seconds after 1970-01-01 00:00:00.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#TO_BASE64">TO_BASE64</a></span></code> </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#TO_DATE">TO_DATE</a></span></code> |
| <div class="block">The "TO_DATE(string1, string2)" function; casts string1 |
| to a DATE using the format specified in string2.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#TO_TIMESTAMP">TO_TIMESTAMP</a></span></code> |
| <div class="block">The "TO_TIMESTAMP(string1, string2)" function; casts string1 |
| to a TIMESTAMP using the format specified in string2.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#TRANSLATE3">TRANSLATE3</a></span></code> |
| <div class="block">The <code>TRANSLATE(<i>string_expr</i>, <i>search_chars</i>, |
| <i>replacement_chars</i>)</code> function returns <i>string_expr</i> with |
| all occurrences of each character in <i>search_chars</i> replaced by its |
| corresponding character in <i>replacement_chars</i>.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#UNIX_DATE">UNIX_DATE</a></span></code> |
| <div class="block">The "UNIX_DATE(date)" function; returns the number of days since |
| 1970-01-01.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#UNIX_MICROS">UNIX_MICROS</a></span></code> |
| <div class="block">The "UNIX_MICROS(bigint)" function; returns the number of microseconds |
| since 1970-01-01 00:00:00.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#UNIX_MILLIS">UNIX_MILLIS</a></span></code> |
| <div class="block">The "UNIX_MILLIS(bigint)" function; returns the number of milliseconds |
| since 1970-01-01 00:00:00.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#UNIX_SECONDS">UNIX_SECONDS</a></span></code> |
| <div class="block">The "UNIX_SECONDS(bigint)" function; returns the number of seconds |
| since 1970-01-01 00:00:00.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a></code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperators.html#XML_TRANSFORM">XML_TRANSFORM</a></span></code> </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.summary"> |
| <!-- --> |
| </a> |
| <h3>Method Summary</h3> |
| <ul class="blockList"> |
| <li class="blockList"><a name="methods.inherited.from.class.java.lang.Object"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></h3> |
| <code><a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#clone--" title="class or interface in java.lang">clone</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#equals-java.lang.Object-" title="class or interface in java.lang">equals</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#finalize--" title="class or interface in java.lang">finalize</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#getClass--" title="class or interface in java.lang">getClass</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#hashCode--" title="class or interface in java.lang">hashCode</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notify--" title="class or interface in java.lang">notify</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notifyAll--" title="class or interface in java.lang">notifyAll</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#toString--" title="class or interface in java.lang">toString</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait--" title="class or interface in java.lang">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait-long-" title="class or interface in java.lang">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait-long-int-" title="class or interface in java.lang">wait</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| <div class="details"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ============ FIELD DETAIL =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="field.detail"> |
| <!-- --> |
| </a> |
| <h3>Field Detail</h3> |
| <a name="CONVERT_TIMEZONE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CONVERT_TIMEZONE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CONVERT_TIMEZONE</pre> |
| <div class="block">The "CONVERT_TIMEZONE(tz1, tz2, datetime)" function; |
| converts the timezone of <code>datetime</code> from <code>tz1</code> to <code>tz2</code>. |
| This function is only on Redshift, but we list it in PostgreSQL |
| because Redshift does not have its own library.</div> |
| </li> |
| </ul> |
| <a name="DECODE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DECODE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> DECODE</pre> |
| <div class="block">The "DECODE(v, v1, result1, [v2, result2, ...], resultN)" function.</div> |
| </li> |
| </ul> |
| <a name="NVL"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>NVL</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> NVL</pre> |
| <div class="block">The "NVL(value, value)" function.</div> |
| </li> |
| </ul> |
| <a name="LTRIM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LTRIM</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LTRIM</pre> |
| <div class="block">The "LTRIM(string)" function.</div> |
| </li> |
| </ul> |
| <a name="RTRIM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>RTRIM</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> RTRIM</pre> |
| <div class="block">The "RTRIM(string)" function.</div> |
| </li> |
| </ul> |
| <a name="SUBSTR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SUBSTR</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SUBSTR</pre> |
| <div class="block">Oracle's "SUBSTR(string, position [, substringLength ])" function. |
| |
| <p>It has similar semantics to standard SQL's |
| <a href="../../../../../org/apache/calcite/sql/fun/SqlStdOperatorTable.html#SUBSTRING"><code>SqlStdOperatorTable.SUBSTRING</code></a> function but different syntax.</div> |
| </li> |
| </ul> |
| <a name="GREATEST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>GREATEST</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> GREATEST</pre> |
| <div class="block">The "GREATEST(value, value)" function.</div> |
| </li> |
| </ul> |
| <a name="LEAST"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LEAST</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LEAST</pre> |
| <div class="block">The "LEAST(value, value)" function.</div> |
| </li> |
| </ul> |
| <a name="TRANSLATE3"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TRANSLATE3</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TRANSLATE3</pre> |
| <div class="block">The <code>TRANSLATE(<i>string_expr</i>, <i>search_chars</i>, |
| <i>replacement_chars</i>)</code> function returns <i>string_expr</i> with |
| all occurrences of each character in <i>search_chars</i> replaced by its |
| corresponding character in <i>replacement_chars</i>. |
| |
| <p>It is not defined in the SQL standard, but occurs in Oracle and |
| PostgreSQL.</div> |
| </li> |
| </ul> |
| <a name="JSON_TYPE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_TYPE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_TYPE</pre> |
| </li> |
| </ul> |
| <a name="JSON_DEPTH"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_DEPTH</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_DEPTH</pre> |
| </li> |
| </ul> |
| <a name="JSON_LENGTH"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_LENGTH</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_LENGTH</pre> |
| </li> |
| </ul> |
| <a name="JSON_KEYS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_KEYS</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_KEYS</pre> |
| </li> |
| </ul> |
| <a name="JSON_PRETTY"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_PRETTY</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_PRETTY</pre> |
| </li> |
| </ul> |
| <a name="JSON_REMOVE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_REMOVE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_REMOVE</pre> |
| </li> |
| </ul> |
| <a name="JSON_STORAGE_SIZE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>JSON_STORAGE_SIZE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> JSON_STORAGE_SIZE</pre> |
| </li> |
| </ul> |
| <a name="REGEXP_REPLACE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>REGEXP_REPLACE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> REGEXP_REPLACE</pre> |
| </li> |
| </ul> |
| <a name="COMPRESS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COMPRESS</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> COMPRESS</pre> |
| </li> |
| </ul> |
| <a name="EXTRACT_VALUE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXTRACT_VALUE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> EXTRACT_VALUE</pre> |
| </li> |
| </ul> |
| <a name="XML_TRANSFORM"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>XML_TRANSFORM</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> XML_TRANSFORM</pre> |
| </li> |
| </ul> |
| <a name="EXTRACT_XML"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXTRACT_XML</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> EXTRACT_XML</pre> |
| </li> |
| </ul> |
| <a name="EXISTS_NODE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>EXISTS_NODE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> EXISTS_NODE</pre> |
| </li> |
| </ul> |
| <a name="DATE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DATE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> DATE</pre> |
| <div class="block">The "DATE(string)" function, equivalent to "CAST(string AS DATE).</div> |
| </li> |
| </ul> |
| <a name="DATE_FROM_UNIX_DATE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DATE_FROM_UNIX_DATE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> DATE_FROM_UNIX_DATE</pre> |
| <div class="block">The "DATE_FROM_UNIX_DATE(integer)" function; returns a DATE value |
| a given number of seconds after 1970-01-01.</div> |
| </li> |
| </ul> |
| <a name="UNIX_DATE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>UNIX_DATE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> UNIX_DATE</pre> |
| <div class="block">The "UNIX_DATE(date)" function; returns the number of days since |
| 1970-01-01.</div> |
| </li> |
| </ul> |
| <a name="MONTHNAME"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MONTHNAME</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> MONTHNAME</pre> |
| <div class="block">The "MONTHNAME(datetime)" function; returns the name of the month, |
| in the current locale, of a TIMESTAMP or DATE argument.</div> |
| </li> |
| </ul> |
| <a name="DAYNAME"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DAYNAME</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> DAYNAME</pre> |
| <div class="block">The "DAYNAME(datetime)" function; returns the name of the day of the week, |
| in the current locale, of a TIMESTAMP or DATE argument.</div> |
| </li> |
| </ul> |
| <a name="LEFT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>LEFT</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> LEFT</pre> |
| </li> |
| </ul> |
| <a name="REPEAT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>REPEAT</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> REPEAT</pre> |
| </li> |
| </ul> |
| <a name="RIGHT"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>RIGHT</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> RIGHT</pre> |
| </li> |
| </ul> |
| <a name="SPACE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SPACE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SPACE</pre> |
| </li> |
| </ul> |
| <a name="STRCMP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>STRCMP</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> STRCMP</pre> |
| </li> |
| </ul> |
| <a name="SOUNDEX"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SOUNDEX</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SOUNDEX</pre> |
| </li> |
| </ul> |
| <a name="DIFFERENCE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>DIFFERENCE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> DIFFERENCE</pre> |
| </li> |
| </ul> |
| <a name="CONCAT_FUNCTION"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CONCAT_FUNCTION</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CONCAT_FUNCTION</pre> |
| <div class="block">The "CONCAT(arg, ...)" function that concatenates strings. |
| For example, "CONCAT('a', 'bc', 'd')" returns "abcd".</div> |
| </li> |
| </ul> |
| <a name="CONCAT2"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CONCAT2</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CONCAT2</pre> |
| <div class="block">The "CONCAT(arg0, arg1)" function that concatenates strings. |
| For example, "CONCAT('a', 'bc')" returns "abc".</div> |
| </li> |
| </ul> |
| <a name="REVERSE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>REVERSE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> REVERSE</pre> |
| </li> |
| </ul> |
| <a name="FROM_BASE64"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>FROM_BASE64</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> FROM_BASE64</pre> |
| </li> |
| </ul> |
| <a name="TO_BASE64"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TO_BASE64</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TO_BASE64</pre> |
| </li> |
| </ul> |
| <a name="TO_DATE"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TO_DATE</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TO_DATE</pre> |
| <div class="block">The "TO_DATE(string1, string2)" function; casts string1 |
| to a DATE using the format specified in string2.</div> |
| </li> |
| </ul> |
| <a name="TO_TIMESTAMP"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TO_TIMESTAMP</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TO_TIMESTAMP</pre> |
| <div class="block">The "TO_TIMESTAMP(string1, string2)" function; casts string1 |
| to a TIMESTAMP using the format specified in string2.</div> |
| </li> |
| </ul> |
| <a name="TIMESTAMP_SECONDS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TIMESTAMP_SECONDS</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TIMESTAMP_SECONDS</pre> |
| <div class="block">The "TIMESTAMP_SECONDS(bigint)" function; returns a TIMESTAMP value |
| a given number of seconds after 1970-01-01 00:00:00.</div> |
| </li> |
| </ul> |
| <a name="TIMESTAMP_MILLIS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TIMESTAMP_MILLIS</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TIMESTAMP_MILLIS</pre> |
| <div class="block">The "TIMESTAMP_MILLIS(bigint)" function; returns a TIMESTAMP value |
| a given number of milliseconds after 1970-01-01 00:00:00.</div> |
| </li> |
| </ul> |
| <a name="TIMESTAMP_MICROS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TIMESTAMP_MICROS</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TIMESTAMP_MICROS</pre> |
| <div class="block">The "TIMESTAMP_MICROS(bigint)" function; returns a TIMESTAMP value |
| a given number of micro-seconds after 1970-01-01 00:00:00.</div> |
| </li> |
| </ul> |
| <a name="UNIX_SECONDS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>UNIX_SECONDS</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> UNIX_SECONDS</pre> |
| <div class="block">The "UNIX_SECONDS(bigint)" function; returns the number of seconds |
| since 1970-01-01 00:00:00.</div> |
| </li> |
| </ul> |
| <a name="UNIX_MILLIS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>UNIX_MILLIS</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> UNIX_MILLIS</pre> |
| <div class="block">The "UNIX_MILLIS(bigint)" function; returns the number of milliseconds |
| since 1970-01-01 00:00:00.</div> |
| </li> |
| </ul> |
| <a name="UNIX_MICROS"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>UNIX_MICROS</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> UNIX_MICROS</pre> |
| <div class="block">The "UNIX_MICROS(bigint)" function; returns the number of microseconds |
| since 1970-01-01 00:00:00.</div> |
| </li> |
| </ul> |
| <a name="CHR"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>CHR</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> CHR</pre> |
| </li> |
| </ul> |
| <a name="TANH"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>TANH</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> TANH</pre> |
| </li> |
| </ul> |
| <a name="COSH"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>COSH</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> COSH</pre> |
| </li> |
| </ul> |
| <a name="SINH"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SINH</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SINH</pre> |
| </li> |
| </ul> |
| <a name="MD5"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MD5</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> MD5</pre> |
| </li> |
| </ul> |
| <a name="SHA1"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>SHA1</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="class in org.apache.calcite.sql">SqlFunction</a> SHA1</pre> |
| </li> |
| </ul> |
| <a name="INFIX_CAST"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>INFIX_CAST</h4> |
| <pre>public static final <a href="../../../../../org/apache/calcite/sql/SqlOperator.html" title="class in org.apache.calcite.sql">SqlOperator</a> INFIX_CAST</pre> |
| <div class="block">Infix "::" cast operator used by PostgreSQL, for example |
| <code>'100'::INTEGER</code>.</div> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| </div> |
| <!-- ========= END OF CLASS DATA ========= --> |
| <!-- ======= START OF BOTTOM NAVBAR ====== --> |
| <div class="bottomNav"><a name="navbar.bottom"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div> |
| <a name="navbar.bottom.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../../overview-summary.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../help-doc.html">Help</a></li> |
| </ul> |
| <div class="aboutLanguage"><b>Apache Calcite</b></div> |
| </div> |
| <div class="subNav"> |
| <ul class="navList"> |
| <li><a href="../../../../../org/apache/calcite/sql/fun/SqlLibrary.html" title="enum in org.apache.calcite.sql.fun"><span class="typeNameLink">Prev Class</span></a></li> |
| <li><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperatorTableFactory.html" title="class in org.apache.calcite.sql.fun"><span class="typeNameLink">Next Class</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../../index.html?org/apache/calcite/sql/fun/SqlLibraryOperators.html" target="_top">Frames</a></li> |
| <li><a href="SqlLibraryOperators.html" target="_top">No Frames</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../../allclasses-noframe.html">All Classes</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_bottom"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#field.summary">Field</a> | </li> |
| <li>Constr | </li> |
| <li><a href="#methods.inherited.from.class.java.lang.Object">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li><a href="#field.detail">Field</a> | </li> |
| <li>Constr | </li> |
| <li>Method</li> |
| </ul> |
| </div> |
| <a name="skip.navbar.bottom"> |
| <!-- --> |
| </a></div> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| <p class="legalCopy"><small>Copyright © 2012-2020 Apache Software Foundation. All Rights Reserved.</small></p> |
| </body> |
| </html> |