Skip to content

H
h2database
切换分支/标签
查找文件
Normal viewHistoryPermalink
functions.html 5.8 KB
Newer Older
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
1 2 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Thomas Mueller's avatar
Change copyright years.
5c625d99
 
Thomas Mueller committed
3 
Copyright 2004-2011 H2 Group. Multiple-Licensed under the H2 License, Version 1.0,
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 
and under the Eclipse Public License, Version 1.0
(http://h2database.com/html/license.html).
Initial Developer: H2 Group
-->
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head><meta http-equiv="Content-Type" content="text/html;charset=utf-8" /><title>
Functions
</title><link rel="stylesheet" type="text/css" href="stylesheet.css" />
<!-- [search] { -->
<script type="text/javascript" src="navigation.js"></script>
</head><body onload="frameMe();">
<table class="content"><tr class="content"><td class="content"><div class="contentDiv">
<!-- } -->

<h1>Functions</h1>
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
19 20 
<h2>Index</h2>
<h3>Aggregate Functions</h3>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
21 
<!-- syntax-start
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
22 
<p class="notranslate">
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
23 
<c:forEach var="item" items="functionsAggregate">
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
24 
    <a href="#${item.link}" >${item.topic}</a><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
25 
</c:forEach>
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
26 
</p>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 
syntax-end -->
<!-- railroad-start -->
<table class="notranslate index">
    <tr>
        <td class="index">
            <c:forEach var="item" items="functionsAggregate-0">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsAggregate-1">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsAggregate-2">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td>
    </tr>
</table>
<!-- railroad-end -->
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
47
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
48 
<h3>Numeric Functions</h3>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
49 
<!-- syntax-start
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
50 
<p class="notranslate">
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
51 
<c:forEach var="item" items="functionsNumeric">
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
52 
    <a href="#${item.link}" >${item.topic}</a><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
53 
</c:forEach>
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
54 
</p>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 
syntax-end -->
<!-- railroad-start -->
<table class="notranslate index">
    <tr>
        <td class="index">
            <c:forEach var="item" items="functionsNumeric-0">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsNumeric-1">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsNumeric-2">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td>
    </tr>
</table>
<!-- railroad-end -->
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
75
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
76 
<h3>String Functions</h3>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
77 
<!-- syntax-start
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
78 
<p class="notranslate">
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
79 
<c:forEach var="item" items="functionsString">
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
80 
    <a href="#${item.link}" >${item.topic}</a><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
81 
</c:forEach>
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
82 
</p>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 
syntax-end -->
<!-- railroad-start -->
<table class="notranslate index">
    <tr>
        <td class="index">
            <c:forEach var="item" items="functionsString-0">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsString-1">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsString-2">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td>
    </tr>
</table>
<!-- railroad-end -->
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
103
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
104 
<h3>Time and Date Functions</h3>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
105 
<!-- syntax-start
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
106 
<p class="notranslate">
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
107 
<c:forEach var="item" items="functionsTimeDate">
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
108 
    <a href="#${item.link}" >${item.topic}</a><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
109 
</c:forEach>
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
110 
</p>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 
syntax-end -->
<!-- railroad-start -->
<table class="notranslate index">
    <tr>
        <td class="index">
            <c:forEach var="item" items="functionsTimeDate-0">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsTimeDate-1">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsTimeDate-2">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td>
    </tr>
</table>
<!-- railroad-end -->
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
131
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
132 
<h3>System Functions</h3>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
133 
<!-- syntax-start
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
134 
<p class="notranslate">
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
135 
<c:forEach var="item" items="functionsSystem">
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
136 
    <a href="#${item.link}" >${item.topic}</a><br />
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
137 
</c:forEach>
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
138 
</p>
Thomas Mueller's avatar
HTML railroad diagrams
2a1545d7
 
Thomas Mueller committed
139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 
syntax-end -->
<!-- railroad-start -->
<table class="notranslate index">
    <tr>
        <td class="index">
            <c:forEach var="item" items="functionsSystem-0">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsSystem-1">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td><td class="index">
            <c:forEach var="item" items="functionsSystem-2">
                <a href="#${item.link}" >${item.topic}</a><br />
            </c:forEach>
        </td>
    </tr>
</table>
<!-- railroad-end -->
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
159
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
160 161 162 163 164 
<!-- railroad-start -->
<h2>Details</h2>
<p>Click on the header to switch between railroad diagram and BNF.</p>
<!-- railroad-end -->
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
165 
<c:forEach var="item" items="functionsAll">
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
166 
<h3 id="${item.link}" class="notranslate" onclick="switchBnf(this)">${item.topic}</h3>
Thomas Mueller's avatar
HTML railroad diagrams
31ed2e1e
 
Thomas Mueller committed
167 
<!-- railroad-start -->
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
168 169 170 171 
<pre name="bnf" style="display: none">
${item.syntax}
</pre>
<div name="railroad">
Thomas Mueller's avatar
HTML railroad diagrams
31ed2e1e
 
Thomas Mueller committed
172 
${item.railroad}
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
173 
</div>
Thomas Mueller's avatar
HTML railroad diagrams
31ed2e1e
 
Thomas Mueller committed
174 175 
<!-- railroad-end -->
<!-- syntax-start
Thomas Mueller's avatar
Documentation: improved website translation
20294dfb
 
Thomas Mueller committed
176 
<pre>
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
177 178 
${item.syntax}
</pre>
Thomas Mueller's avatar
HTML railroad diagrams
31ed2e1e
 
Thomas Mueller committed
179 
syntax-end -->
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
180 
<p>${item.text}</p>
Thomas Mueller's avatar
HTML railroad diagrams
11095888
 
Thomas Mueller committed
181 
<p>Example:</p>
Thomas Mueller's avatar
Documentation: add 'notranslate' tags
ca717c37
 
Thomas Mueller committed
182 
<p class="notranslate">${item.example}</p>
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
183 184 
</c:forEach>
Thomas Mueller's avatar
Documentation.
8499f80e
 
Thomas Mueller committed
185 186 
<!--[if lte IE 7]><script language="javascript">switchBnf(null);</script><![endif]-->
Thomas Mueller's avatar
use unix newline, no trailing spaces
1e7406b5
 
Thomas Mueller committed
187 188 
<!-- [close] { --></div></td></tr></table><!-- } --><!-- analytics --></body></html>