functions.html 5.4 KB
Newer Older
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
Thomas Mueller committed
3
Copyright 2004-2009 H2 Group. Multiple-Licensed under the H2 License, Version 1.0,
4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
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>

<h2>Aggregate Functions</h2>
21
<!-- syntax-start
22
<p class="notranslate">
23
<c:forEach var="item" items="functionsAggregate">
24
    <a href="#${item.link}" >${item.topic}</a><br />
25
</c:forEach>
26
</p>
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 -->
47 48

<h2>Numeric Functions</h2>
49
<!-- syntax-start
50
<p class="notranslate">
51
<c:forEach var="item" items="functionsNumeric">
52
    <a href="#${item.link}" >${item.topic}</a><br />
53
</c:forEach>
54
</p>
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 -->
75 76

<h2>String Functions</h2>
77
<!-- syntax-start
78
<p class="notranslate">
79
<c:forEach var="item" items="functionsString">
80
    <a href="#${item.link}" >${item.topic}</a><br />
81
</c:forEach>
82
</p>
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 -->
103 104

<h2>Time and Date Functions</h2>
105
<!-- syntax-start
106
<p class="notranslate">
107
<c:forEach var="item" items="functionsTimeDate">
108
    <a href="#${item.link}" >${item.topic}</a><br />
109
</c:forEach>
110
</p>
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 -->
131 132

<h2>System Functions</h2>
133
<!-- syntax-start
134
<p class="notranslate">
135
<c:forEach var="item" items="functionsSystem">
136
    <a href="#${item.link}" >${item.topic}</a><br />
137
</c:forEach>
138
</p>
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 -->
159 160

<c:forEach var="item" items="functionsAll">
161
<h3 id="${item.link}" class="notranslate">${item.topic}</h3>
162 163 164 165
<!-- railroad-start -->
${item.railroad}
<!-- railroad-end -->
<!-- syntax-start
166
<pre>
167 168
${item.syntax}
</pre>
169
syntax-end -->
170
<p>${item.text}</p>
171
<p>Example:</p>
172
<p class="notranslate">${item.example}</p>
173 174 175 176
</c:forEach>

<!-- [close] { --></div></td></tr></table><!-- } --><!-- analytics --></body></html>