blob: 4593fb48f1ece475439a69f60066be10912a3bfe [file] [log] [blame]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="zh">
<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。</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar.top">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.top" title="跳过导航链接">跳过导航链接</a></div>
<a name="navbar.top.firstrow">
<!-- -->
</a>
<ul class="navList" title="导航">
<li><a href="../../../../../overview-summary.html">概览</a></li>
<li><a href="package-summary.html">程序包</a></li>
<li class="navBarCell1Rev"></li>
<li><a href="package-tree.html"></a></li>
<li><a href="../../../../../deprecated-list.html">已过时</a></li>
<li><a href="../../../../../index-all.html">索引</a></li>
<li><a href="../../../../../help-doc.html">帮助</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="org.apache.calcite.sql.fun中的枚举"><span class="typeNameLink">上一个类</span></a></li>
<li><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperatorTableFactory.html" title="org.apache.calcite.sql.fun中的类"><span class="typeNameLink">下一个类</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/calcite/sql/fun/SqlLibraryOperators.html" target="_top">框架</a></li>
<li><a href="SqlLibraryOperators.html" target="_top">无框架</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../allclasses-noframe.html">所有类</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>概要:&nbsp;</li>
<li>嵌套&nbsp;|&nbsp;</li>
<li><a href="#field.summary">字段</a>&nbsp;|&nbsp;</li>
<li>构造器&nbsp;|&nbsp;</li>
<li><a href="#methods.inherited.from.class.java.lang.Object">方法</a></li>
</ul>
<ul class="subNavList">
<li>详细资料:&nbsp;</li>
<li><a href="#field.detail">字段</a>&nbsp;|&nbsp;</li>
<li>构造器&nbsp;|&nbsp;</li>
<li>方法</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="类 SqlLibraryOperators" class="title">类 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="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="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="org.apache.calcite.sql.fun中的类"><code>SqlLibraryOperatorTableFactory</code></a> into instances
of <a href="../../../../../org/apache/calcite/sql/SqlOperatorTable.html" title="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>字段概要</h3>
<table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="字段概要表, 列表字段和解释">
<caption><span>字段</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">限定符和类型</th>
<th class="colLast" scope="col">字段和说明</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="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="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="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="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="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="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="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>&nbsp;</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="rowColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="altColor">
<td class="colFirst"><code>static <a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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>&nbsp;</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method.summary">
<!-- -->
</a>
<h3>方法概要</h3>
<ul class="blockList">
<li class="blockList"><a name="methods.inherited.from.class.java.lang.Object">
<!-- -->
</a>
<h3>从类继承的方法&nbsp;java.lang.<a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true" title="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="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="java.lang中的类或接口">equals</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#finalize--" title="java.lang中的类或接口">finalize</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#getClass--" title="java.lang中的类或接口">getClass</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#hashCode--" title="java.lang中的类或接口">hashCode</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notify--" title="java.lang中的类或接口">notify</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#notifyAll--" title="java.lang中的类或接口">notifyAll</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#toString--" title="java.lang中的类或接口">toString</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait--" title="java.lang中的类或接口">wait</a>, <a href="https://docs.oracle.com/javase/8/docs/api/java/lang/Object.html?is-external=true#wait-long-" title="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="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>字段详细资料</h3>
<a name="CONVERT_TIMEZONE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CONVERT_TIMEZONE</h4>
<pre>public static final&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="org.apache.calcite.sql中的类">SqlFunction</a> REGEXP_REPLACE</pre>
</li>
</ul>
<a name="EXTRACT_VALUE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>EXTRACT_VALUE</h4>
<pre>public static final&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="org.apache.calcite.sql中的类">SqlFunction</a> EXISTS_NODE</pre>
</li>
</ul>
<a name="MONTHNAME">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MONTHNAME</h4>
<pre>public static final&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="org.apache.calcite.sql中的类">SqlFunction</a> SPACE</pre>
</li>
</ul>
<a name="SOUNDEX">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SOUNDEX</h4>
<pre>public static final&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="REVERSE">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>REVERSE</h4>
<pre>public static final&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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="CHR">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>CHR</h4>
<pre>public static final&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="org.apache.calcite.sql中的类">SqlFunction</a> COSH</pre>
</li>
</ul>
<a name="MD5">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>MD5</h4>
<pre>public static final&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlFunction.html" title="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&nbsp;<a href="../../../../../org/apache/calcite/sql/SqlOperator.html" title="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="跳过导航链接">跳过导航链接</a></div>
<a name="navbar.bottom.firstrow">
<!-- -->
</a>
<ul class="navList" title="导航">
<li><a href="../../../../../overview-summary.html">概览</a></li>
<li><a href="package-summary.html">程序包</a></li>
<li class="navBarCell1Rev"></li>
<li><a href="package-tree.html"></a></li>
<li><a href="../../../../../deprecated-list.html">已过时</a></li>
<li><a href="../../../../../index-all.html">索引</a></li>
<li><a href="../../../../../help-doc.html">帮助</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="org.apache.calcite.sql.fun中的枚举"><span class="typeNameLink">上一个类</span></a></li>
<li><a href="../../../../../org/apache/calcite/sql/fun/SqlLibraryOperatorTableFactory.html" title="org.apache.calcite.sql.fun中的类"><span class="typeNameLink">下一个类</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/calcite/sql/fun/SqlLibraryOperators.html" target="_top">框架</a></li>
<li><a href="SqlLibraryOperators.html" target="_top">无框架</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../allclasses-noframe.html">所有类</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>概要:&nbsp;</li>
<li>嵌套&nbsp;|&nbsp;</li>
<li><a href="#field.summary">字段</a>&nbsp;|&nbsp;</li>
<li>构造器&nbsp;|&nbsp;</li>
<li><a href="#methods.inherited.from.class.java.lang.Object">方法</a></li>
</ul>
<ul class="subNavList">
<li>详细资料:&nbsp;</li>
<li><a href="#field.detail">字段</a>&nbsp;|&nbsp;</li>
<li>构造器&nbsp;|&nbsp;</li>
<li>方法</li>
</ul>
</div>
<a name="skip.navbar.bottom">
<!-- -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>Copyright &copy; 2012-2020 Apache Software Foundation. All Rights Reserved.</small></p>
</body>
</html>