Skip to content

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