Author: plavin
Date: 2007-03-09 18:52:09 +0100 (Fri, 09 Mar 2007)
New Revision: 5285
Log:
Add functions
Modified:
trunk/dynamic-docs/opsfunctions/opfunctions.xml
Modified: trunk/dynamic-docs/opsfunctions/opfunctions.xml
===================================================================
--- trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-09 17:12:14 UTC (rev 5284)
+++ trunk/dynamic-docs/opsfunctions/opfunctions.xml 2007-03-09 17:52:09 UTC (rev 5285)
Changed blocks: 9, Lines Added: 177, Lines Deleted: 118; 10520 bytes
@@ -351,116 +351,6 @@
</versions>
</operator>
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
- <operator id="" class="" >
- <display></display>
- <description lang="en"></description>
- <versions>
- <manual version="4.1"/>
- <manual version="5.0"/>
- <manual version="5.1"/>
- </versions>
- </operator>
-
<!-- start functions-->
<function id="case" class="controlflow">
@@ -514,7 +404,7 @@
</versions>
</function>
- <function id="abs" class="arithmetic">
+ <function id="abs" class="mathematical">
<display>ABS</display>
<description lang="en">Return the absolute value</description>
<arguments>
@@ -530,7 +420,7 @@
</versions>
</function>
- <function id="acos" class="trigonometric">
+ <function id="acos" class="mathematical">
<display>ACOS</display>
<description lang="en">Return the arc cosine</description>
<arguments>
@@ -546,9 +436,9 @@
</versions>
</function>
- <function id="asin" class="trigonometric">
+ <function id="asin" class="mathematical">
<display>ASIN</display>
- <description lang="en">Retrun the arc sine</description>
+ <description lang="en">Return the arc sine</description>
<arguments>
<format><![CDATA[ASIN(<replaceable>X</replaceable>)]]></format>
<argument seq="1" name="expr" type="numeric"></argument>
@@ -562,7 +452,7 @@
</versions>
</function>
- <function id="atan" class="trigonometric">
+ <function id="atan" class="mathematical">
<display>ATAN</display>
<description lang="en">Return the arc tangent</description>
<arguments>
@@ -577,7 +467,7 @@
<manual version="5.1"/>
</versions>
</function>
- <function id="atan2" class="trigonometric">
+ <function id="atan2" class="mathematical">
<display>ATAN2</display>
<display>ATAN</display>
<description lang="en">Returns the arc tangent of the two arguments</description>
@@ -614,7 +504,7 @@
</versions>
</function>
- <function id="cos" class="trigonometric">
+ <function id="cos" class="mathematical">
<display>COS</display>
<description lang="en">Return the cosine</description>
<arguments>
@@ -662,13 +552,62 @@
</versions>
</function>
- <function id="degrees" class="trigonometric">
+ <function id="degrees" class="mathematical">
<display>DEGREES</display>
<description lang="en">Convert radians to degrees</description>
<arguments>
<format><![CDATA[DEGREES(<replaceable>X</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric">Radians</argument>
+ </arguments>
+ <return type="value"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+
+ <function id="exp" class="mathematical">
+ <display>EXP</display>
+ <description lang="en">Raise to the power of</description>
+ <arguments>
+ <format><![CDATA[EXP(<replaceable>X</replaceable>)]]></format>
<argument seq="1" name="expr" type="numeric"></argument>
</arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="from-days" class="date-time">
+ <display>FROM_DAYS</display>
+ <description lang="en">Convert number to date</description>
+ <arguments>
+ <format><![CDATA[FROM_DAYS(<replaceable>N</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="date"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="floor" class="mathematical">
+ <display>FLOOR</display>
+ <description lang="en">Round up to the nearest integer</description>
+ <arguments>
+ <format><![CDATA[FLOOR(<replaceable>X</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
<return type="value"/>
<error type="return"/>
<versions>
@@ -677,5 +616,125 @@
<manual version="5.1"/>
</versions>
</function>
+
+ <function id="ln" class="mathematical">
+ <display>LN</display>
+ <description lang="en">Return the natural logarithm of the argument</description>
+ <arguments>
+ <format><![CDATA[LN(<replaceable>X</replaceable>)<]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="log" class="mathematical">
+ <display>LOG</display>
+ <description lang="en">
+ Return the natural logarithm of the first argument.
+ The second argument specifies the base.
+ </description>
+ <arguments>
+ <format><![CDATA[LOG(<replaceable>B</replaceable>)]]></format>
+ <format><![CDATA[LOG(<replaceable>B</replaceable>,<replaceable>X</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ <argument seq="2" name="expr" type="numeric">Base</argument>
+ </arguments>
+ <return type="value"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="log2" class="mathematical">
+ <display>LOG2</display>
+ <description lang="en">Return the base-2 logarithm of the argument</description>
+ <arguments>
+ <format><![CDATA[LOG2(<replaceable>X</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="log10" class="">
+ <display>LOG10</display>
+ <description lang="en">Return the base-10 logarithm of the argument</description>
+ <arguments>
+ <format><![CDATA[LOG10(<replaceable>X</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="numeric"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="mod" class="mathematical">
+ <display>MOD</display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[MOD(<replaceable>N</replaceable>,<replaceable>M</replaceable>)]]></format>
+ <argument seq="1" name="expr" type="numeric">Dividend</argument>
+ <argument seq="2" name="expr" type="numeric">Divisor</argument>
+ </arguments>
+ <return type="value"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="value"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+ <function id="" class="">
+ <display></display>
+ <description lang="en"></description>
+ <arguments>
+ <format><![CDATA[]]></format>
+ <argument seq="1" name="expr" type="numeric"></argument>
+ </arguments>
+ <return type="value"/>
+ <error type="return"/>
+ <versions>
+ <manual version="4.1"/>
+ <manual version="5.0"/>
+ <manual version="5.1"/>
+ </versions>
+ </function>
+
+
</opfunctions>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r5285 - trunk/dynamic-docs/opsfunctions | plavin | 9 Mar |
