You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by dj...@apache.org on 2006/08/15 00:44:54 UTC

svn commit: r431457 - /db/derby/docs/trunk/src/ref/

Author: djd
Date: Mon Aug 14 15:44:53 2006
New Revision: 431457

URL: http://svn.apache.org/viewvc?rev=431457&view=rev
Log:
DERBY-1548 Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP,
LN, LOG, LOG10, CEIL, CEILING, FLOOR
Patch contributed by Laura Stewart - scotsmatrix@gmail.com

Added:
    db/derby/docs/trunk/src/ref/rreffuncacos.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncasin.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncatan.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncceil.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffunccos.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncdegrees.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncexp.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncfloor.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffunclog.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffunclog10.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncpi.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncradians.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffuncsin.dita   (with props)
    db/derby/docs/trunk/src/ref/rreffunctan.dita   (with props)
Modified:
    db/derby/docs/trunk/src/ref/refderby.ditamap
    db/derby/docs/trunk/src/ref/rrefsqlj55788.dita

Modified: db/derby/docs/trunk/src/ref/refderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/refderby.ditamap?rev=431457&r1=431456&r2=431457&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/refderby.ditamap (original)
+++ db/derby/docs/trunk/src/ref/refderby.ditamap Mon Aug 14 15:44:53 2006
@@ -1,4 +1,5 @@
 <?xml version="1.0" encoding="utf-8"?>
+ 
 <!DOCTYPE map PUBLIC "-//OASIS//DTD DITA Map//EN"
  "map.dtd">
 <!-- 
@@ -154,14 +155,16 @@
 <topicref href="rrefsqlj33923.dita" navtitle="Aggregates (set functions)">
 </topicref>
 <topicref href="rrefsqlj98067.dita" navtitle="ABS or ABSVAL"></topicref>
+<topicref href="rreffuncacos.dita" navtitle="ACOS function"></topicref>
+<topicref href="rreffuncasin.dita" navtitle="ASIN function"></topicref>
+<topicref href="rreffuncatan.dita" navtitle="ATAN function"></topicref>
 <topicref href="rrefsqlj32693.dita" navtitle="AVG"></topicref>
 <topicref href="rrefbuiltbigint.dita" navtitle="BIGINT"></topicref>
 <topicref href="rrefsqlj33562.dita" navtitle="CAST"></topicref>
+<topicref href="rreffuncceil.dita" navtitle="CEIL or CEILING function"></topicref>
 <topicref href="rrefbuiltchar.dita" navtitle="CHAR"></topicref>
-<topicref href="rrefsqlj16762.dita" navtitle="LENGTH"></topicref>
 <topicref href="rrefsqlj40899.dita" navtitle="Concatenation"></topicref>
-<topicref href="rrefcasenullif.dita" navtitle="NULLIF and CASE expressions">
-</topicref>
+<topicref href="rreffunccos.dita" navtitle="COS function"></topicref>
 <topicref href="rrefsqlj38716.dita" navtitle="COUNT"></topicref>
 <topicref href="rrefsqlj66113.dita" navtitle="COUNT(*)"></topicref>
 <topicref href="rrefsqljcurrentdate.dita" navtitle="CURRENT DATE"></topicref>
@@ -176,25 +179,37 @@
 <topicref href="rrefsqlj42324.dita" navtitle="CURRENT_USER"></topicref>
 <topicref href="rrefdatefunc.dita" navtitle="DATE"></topicref>
 <topicref href="rrefdayfunc.dita" navtitle="DAY"></topicref>
+<topicref href="rreffuncdegrees.dita" navtitle="DEGREES function"></topicref>
 <topicref href="rrefbuiltdouble.dita" navtitle="DOUBLE"></topicref>
+<topicref href="rreffuncexp.dita" navtitle="EXP function"></topicref>
+<topicref href="rreffuncfloor.dita" navtitle="FLOOR function"></topicref>
 <topicref href="rrefhourfunc.dita" navtitle="HOUR"></topicref>
 <topicref href="rrefidentityvallocal.dita" navtitle="IDENTITY_VAL_LOCAL">
 </topicref>
 <topicref href="rrefbuiltinteger.dita" navtitle="INTEGER"></topicref>
-<topicref href="rrefsqlj61998.dita" navtitle="LOCATE"></topicref>
 <topicref href="rrefsqlj42049.dita" navtitle="LCASE or LOWER"></topicref>
+<topicref href="rrefsqlj16762.dita" navtitle="LENGTH"></topicref>
+<topicref href="rreffunclog.dita" navtitle="LN or LOG function"></topicref>
+<topicref href="rreffunclog10.dita" navtitle="LOG10 function"></topicref>
+<topicref href="rrefsqlj61998.dita" navtitle="LOCATE"></topicref>
 <topicref href="rrefsqlj97870.dita" navtitle="LTRIM"></topicref>
 <topicref href="rrefsqlj27781.dita" navtitle="MAX"></topicref>
 <topicref href="rrefsqlj33520.dita" navtitle="MIN"></topicref>
 <topicref href="rrefminutefunc.dita" navtitle="MINUTE"></topicref>
 <topicref href="rrefsqljmod.dita" navtitle="MOD"></topicref>
 <topicref href="rrefmonthfunc.dita" navtitle="MONTH"></topicref>
+<topicref href="rrefcasenullif.dita" navtitle="NULLIF and CASE expressions">
+</topicref>
+<topicref href="rreffuncpi.dita" navtitle="PI function"></topicref>
+<topicref href="rreffuncradians.dita" navtitle="RADIANS function"></topicref>
 <topicref href="rrefsqlj32613.dita" navtitle="RTRIM"></topicref>
 <topicref href="rrefsecondfunc.dita" navtitle="SECOND"></topicref>
 <topicref href="rrefsqlj25228.dita" navtitle="SESSION_USER"></topicref>
+<topicref href="rreffuncsin.dita" navtitle="SIN function"></topicref>
 <topicref href="rrefbuiltsmallint.dita" navtitle="SMALLINT"></topicref>
 <topicref href="rrefsqlj73147.dita" navtitle="SQRT"></topicref>
 <topicref href="rrefsqlj93082.dita" navtitle="SUBSTR"></topicref>
+<topicref href="rreffunctan.dita" navtitle="TAN function"></topicref>
 <topicref href="rrefsqlj13083.dita" navtitle="SUM"></topicref>
 <topicref href="rreftimefunc.dita" navtitle="TIME"></topicref>
 <topicref href="rreftimestampfunc.dita" navtitle="TIMESTAMP"></topicref>
@@ -423,11 +438,16 @@
 </topicref>
 </topicref>
 <topicref collection-type="family" href="rrefjdbc4_0summary.dita" navtitle="JDBC 4.0-only features ">
-<topicref href="rrefjdbc4_0sqlexception.dita" navtitle="Refined subclasses of SQLException"></topicref>
-<topicref href="rrefjdbc4_0connection.dita" navtitle="java.sql.Connection"></topicref>
-<topicref href="rrefjdbc4_0databaseMetaData.dita" navtitle="java.sql.DatabaseMetaData"></topicref>
-<topicref href="rrefjdbc4_0statement.dita" navtitle="java.sql.Statement"></topicref>
-<topicref href="rrefjdbc4_0dataSource.dita" navtitle="javax.sql.DataSource"></topicref>
+<topicref href="rrefjdbc4_0sqlexception.dita" navtitle="Refined subclasses of SQLException">
+</topicref>
+<topicref href="rrefjdbc4_0connection.dita" navtitle="java.sql.Connection">
+</topicref>
+<topicref href="rrefjdbc4_0databaseMetaData.dita" navtitle="java.sql.DatabaseMetaData">
+</topicref>
+<topicref href="rrefjdbc4_0statement.dita" navtitle="java.sql.Statement">
+</topicref>
+<topicref href="rrefjdbc4_0dataSource.dita" navtitle="javax.sql.DataSource">
+</topicref>
 </topicref>
 <topicref collection-type="family" href="rrefjdbc1020262.dita" navtitle="JDBC escape syntax ">
 <topicref href="rrefjdbc70824.dita" navtitle="JDBC escape keyword for call statements">

Added: db/derby/docs/trunk/src/ref/rreffuncacos.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncacos.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncacos.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncacos.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncacos" xml:lang="en-us">
+<title>ACOS function</title>
+<shortdesc>The ACOS function returns the arc cosine of a specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>ACOS function</indexterm><indexterm>functions<indexterm>ACOS</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number is the cosine, in radians, of the angle
+that you want. The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number.  <ul>
+<li>If the specified number is NULL, the result of this function is NULL. </li>
+<li>If the absolute value of the specified number is greater than 1, an exception
+is returned that indicates that the value is out of range (SQL state 22003).</li>
+</ul></p><p>The returned value, in radians, is in the range of zero (0) to <term>pi</term>.
+The data type of the returned value is a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title> <codeblock><b>ACOS ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncacos.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncasin.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncasin.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncasin.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncasin.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncasin" xml:lang="en-us">
+<title>ASIN function</title>
+<shortdesc>The ASIN function returns the arc sine of a specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>ASIN function</indexterm><indexterm>functions<indexterm>ASIN</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number is the sine, in radians, of the angle that
+you want. The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number.  <ul>
+<li>If the specified number is NULL, the result of this function is NULL. </li>
+<li>If the specified number is zero (0), the result of this function is zero
+with the same sign as the specified number.</li>
+<li>If the absolute value of the specified number is greater than 1, an exception
+is returned that indicates that the value is out of range (SQL state 22003).</li>
+</ul></p><p>The returned value, in radians, is in the range -<term>pi</term>/2
+to <term>pi</term>/2. The data type of the returned value is a DOUBLE PRECISION
+number.</p> </section>
+<refsyn><title>Syntax</title> <codeblock><b>ASIN ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncasin.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncatan.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncatan.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncatan.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncatan.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncatan" xml:lang="en-us">
+<title>ATAN function</title>
+<shortdesc>The ATAN function returns the arc tangent of a specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>ATAN function</indexterm><indexterm>functions<indexterm>ATAN</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number is the tangent, in radians, of the angle
+that you want. The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number.  <ul>
+<li>If the specified number is NULL, the result of this function is NULL. </li>
+<li>If the specified number is zero (0), the result of this function is zero
+with the same sign as the specified number.</li>
+</ul></p><p>The returned value, in radians, is in the range -<term>pi</term>/2
+to <term>pi</term>/2. The data type of the returned value is a DOUBLE PRECISION
+number.</p> </section>
+<refsyn><title>Syntax</title> <codeblock><b>ATAN ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncatan.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncceil.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncceil.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncceil.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncceil.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,48 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncceil" xml:lang="en-us">
+<title>CEIL or CEILING function</title>
+<shortdesc>The CEIL and CEILING functions round the specified number up, and
+return the smallest number that is greater than or equal to the specified
+number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>CEIL function</indexterm><indexterm>functions<indexterm>CEIL</indexterm></indexterm>
+<indexterm>CEILING function</indexterm><indexterm>functions<indexterm>CEILING</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number.  <ul>
+<li>If the specified number is NULL, the result of these functions is NULL.</li>
+<li>If the specified number is equal to a mathematical integer, the result
+of these functions is the same as the specified number.</li>
+<li>If the specified number is zero (0), the result of these functions is
+zero.</li>
+<li>If the specified number is less than zero but greater than -1.0, then
+the result of these functions is negative zero.</li>
+</ul></p><p>The returned value is the smallest (closest to negative infinity)
+double floating point value that is greater than or equal to the specified
+number. The returned value is equal to a mathematical integer. The data type
+of the returned value is a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title> <codeblock><b>CEIL ( <varname>number</varname> )</b></codeblock><codeblock><b>CEILING ( <varname>number</varname> )</b
+></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncceil.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffunccos.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffunccos.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffunccos.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffunccos.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffunccos" xml:lang="en-us">
+<title>COS function</title>
+<shortdesc>The COS function returns the cosine of a specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>COS function</indexterm><indexterm>functions<indexterm>COS</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p> The specified number is the angle, in radians, that you want
+the cosine for.  The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number.  <ul>
+<li>If the specified number is NULL, the result of this function is NULL. </li>
+</ul></p> </section>
+<refsyn><title>Syntax</title> <codeblock><b>COS ( <i>number</i> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffunccos.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncdegrees.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncdegrees.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncdegrees.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncdegrees.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,39 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncdegrees" xml:lang="en-us">
+<title>DEGREES function</title>
+<shortdesc>The DEGREES function converts a specified number from radians to
+degrees.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>DEGREES function</indexterm><indexterm>functions<indexterm>DEGREES</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p> The specified number is an angle measured in radians, which
+is converted to an approximately equivalent angle measured in degrees. The
+specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number. </p><p><note type="attention">The conversion from
+radians to degrees is not exact. You should not expect that the COS(RADIANS(90.0))
+to exactly equal 0.0.</note> </p><p>The data type of the returned value is
+a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title><codeblock><b>DEGREES ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncdegrees.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncexp.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncexp.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncexp.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncexp.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,37 @@
+<?xml version="1.0" encoding="utf-8"?>
+
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncexp" xml:lang="en-us">
+<title>EXP function</title>
+<shortdesc>The EXP function returns <term>e</term> raised to the power of
+the specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>EXP function</indexterm><indexterm>functions<indexterm>EXP</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number is the exponent that you want to raise <term>e</term> to.
+The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number. </p><p>The constant <term>e</term> is the base of
+the natural logarithms. </p><p>The data type of the returned value is a DOUBLE
+PRECISION number.</p> </section>
+<refsyn><title>Syntax</title><codeblock><b>EXP ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncexp.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncfloor.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncfloor.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncfloor.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncfloor.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,42 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncfloor" xml:lang="en-us">
+<title>FLOOR function</title>
+<shortdesc>The FLOOR function rounds the specified number down, and returns
+the largest number that is less than or equal to the specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>FLOOR function</indexterm><indexterm>functions<indexterm>FLOOR</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number. </p><p><ul>
+<li>If the specified number is NULL, the result of this function is NULL.</li>
+<li>If the specified number is equal to a mathematical integer, the result
+of this function is the same as the specified number.</li>
+<li>If the specified number is zero (0), the result of this function is zero.</li>
+</ul></p><p>The returned value is the largest (closest to positive infinity)
+double floating point value that is less than or equal to the specified number.
+The returned value is equal to a mathematical integer. The data type of the
+returned value is a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title><codeblock><b>FLOOR ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncfloor.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffunclog.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffunclog.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffunclog.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffunclog.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,40 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffunclog" xml:lang="en-us">
+<title>LN or LOG function</title>
+<shortdesc>The LN and LOG functions return the natural logarithm (base <term>e</term>)
+of the specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>LN function</indexterm><indexterm>functions<indexterm>LN</indexterm></indexterm>
+<indexterm>LOG function</indexterm><indexterm>functions<indexterm>LOG</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number that is greater than zero (0).  <ul>
+<li>If the specified number is NULL, the result of these functions is NULL.</li>
+<li>If the specified number is zero or a negative number, an exception is
+returned that indicates that the value is out of range (SQL state 22003).</li>
+</ul></p><p>The data type of the returned value is a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title><codeblock><b>LN ( <varname>number</varname> )</b></codeblock><codeblock><b>LOG ( <varname>number</varname> )</b></codeblock
+> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffunclog.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffunclog10.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffunclog10.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffunclog10.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffunclog10.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,38 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffunclog10" xml:lang="en-us">
+<title>LOG10 function</title>
+<shortdesc>The LOG10 function returns the base-10 logarithm of the specified
+number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>LOG10 function</indexterm><indexterm>functions<indexterm>LOG10</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number that is greater than zero (0).  <ul>
+<li>If the specified number is NULL, the result of this function is NULL.</li>
+<li>If the specified number is zero or a negative number, an exception is
+returned that indicates that the value is out of range (SQL state 22003).</li>
+</ul></p><p>The data type of the returned value is a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title><codeblock><b>LOG10 ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffunclog10.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncpi.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncpi.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncpi.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncpi.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,36 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncpi" xml:lang="en-us">
+<title>PI function</title>
+<shortdesc>The PI function returns a value that is closer than any other value
+to <term>pi</term>.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>PI function</indexterm><indexterm>functions<indexterm>PI</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p> The constant <term>pi</term> is the ratio of the circumference
+of a circle to the diameter of a circle.</p><p>The data type of the returned
+value is a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number. </p> </section>
+<refsyn><title>Syntax</title><codeblock><b>PI (  )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncpi.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncradians.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncradians.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncradians.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncradians.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,38 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncradians" xml:lang="en-us">
+<title>RADIANS function</title>
+<shortdesc>The RADIANS function converts a specified number from degrees to
+radians.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>RADIANS function</indexterm><indexterm>functions<indexterm>RADIANS</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p> The specified number is an angle measured in degrees, which
+is converted to an approximately equivalent angle measured in radians. The
+specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number. </p><p><note type="attention">The conversion from
+degrees to radians is not exact. </note> </p><p>The data type of the returned
+value is a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title><codeblock><b>RADIANS ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncradians.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffuncsin.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffuncsin.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffuncsin.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffuncsin.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,37 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffuncsin" xml:lang="en-us">
+<title>SIN function</title>
+<shortdesc>The SIN function returns the sine of a specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>SIN function</indexterm><indexterm>functions<indexterm>SIN</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number is the angle, in radians, that you want
+the sine for. The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number.  <ul>
+<li>If the specified number is NULL, the result of this function is NULL.</li>
+<li>If the specified number is zero (0), the result of this function is zero.</li>
+</ul></p><p>The data type of the returned value is a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title> <codeblock><b>SIN ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffuncsin.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rreffunctan.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rreffunctan.dita?rev=431457&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rreffunctan.dita (added)
+++ db/derby/docs/trunk/src/ref/rreffunctan.dita Mon Aug 14 15:44:53 2006
@@ -0,0 +1,38 @@
+<?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<reference id="rreffunctan" xml:lang="en-us">
+<title>TAN function</title>
+<shortdesc>The TAN function returns the tangent of a specified number.</shortdesc>
+<prolog><metadata>
+<keywords><indexterm>TAN function</indexterm><indexterm>functions<indexterm>TAN</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section> <p>The specified number is the angle, in radians, that you want
+the tangent for. The specified number must be a <xref href="rrefsqljdoubleprecision.dita#rrefsqljdoubleprecision">DOUBLE
+PRECISION</xref> number.  <ul>
+<li>If the specified number is NULL, the result of this function is NULL.</li>
+<li>If the specified number is zero (0), the result of this function is zero
+with the same sign as the specified number.</li>
+</ul></p><p>The data type of the returned value is a DOUBLE PRECISION number.</p> </section>
+<refsyn><title>Syntax</title> <codeblock><b>TAN ( <varname>number</varname> )</b></codeblock> </refsyn>
+</refbody>
+</reference>

Propchange: db/derby/docs/trunk/src/ref/rreffunctan.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/docs/trunk/src/ref/rrefsqlj55788.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj55788.dita?rev=431457&r1=431456&r2=431457&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj55788.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj55788.dita Mon Aug 14 15:44:53 2006
@@ -1,4 +1,7 @@
 <?xml version="1.0" encoding="utf-8"?>
+ 
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
 <!-- 
 Licensed to the Apache Software Foundation (ASF) under one or more
 contributor license agreements.  See the NOTICE file distributed with
@@ -15,18 +18,24 @@
 See the License for the specific language governing permissions and  
 limitations under the License.
 -->
-
-<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
 <reference id="rrefsqlj55788" xml:lang="en-us">
 <title>Standard built-in functions</title>
+<prolog><metadata>
+<keywords><indexterm>functions<indexterm>standard built-in, list of</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
 <refbody>
-<section> <ul>
+<section> <p>The standard built-in functions supported in Derby are as follows:</p><ul>
 <li><xref href="rrefsqlj98067.dita#rrefsqlj98067"></xref></li>
+<li><xref href="rreffuncacos.dita#rreffuncacos">ACOS</xref></li>
+<li><xref href="rreffuncasin.dita#rreffuncasin">ASIN</xref></li>
+<li><xref href="rreffuncatan.dita#rreffuncatan">ATAN</xref></li>
 <li><xref href="rrefbuiltbigint.dita#rrefbuiltbigint"></xref></li>
 <li><xref href="rrefsqlj33562.dita#rrefsqlj33562"></xref></li>
+<li><xref href="rreffuncceil.dita#rreffuncceil">CEIL or CEILING</xref></li>
 <li><xref href="rrefbuiltchar.dita#rrefbuiltchar"></xref></li>
 <li><xref href="rrefsqlj40899.dita#rrefsqlj40899"></xref></li>
+<li><xref href="rreffunccos.dita#rreffunccos">COS</xref></li>
 <li><xref href="rrefcasenullif.dita#rrefcasenullif"></xref></li>
 <li><xref href="rrefsqlj34177.dita#rrefsqlj34177"></xref></li>
 <li><xref href="rrefcurrentisolation.dita#rrefcurrentisolation"></xref></li>
@@ -35,23 +44,32 @@
 <li><xref href="rrefsqlj42324.dita#rrefsqlj42324"></xref></li>
 <li><xref href="rrefdatefunc.dita#rrefdatefunc"></xref></li>
 <li><xref href="rrefdayfunc.dita#rrefdayfunc"></xref></li>
+<li><xref href="rreffuncdegrees.dita#rreffuncdegrees">DEGREES</xref></li>
 <li><xref href="rrefbuiltdouble.dita#rrefbuiltdouble"></xref></li>
+<li><xref href="rreffuncexp.dita#rreffuncexp">EXP</xref></li>
+<li><xref href="rreffuncfloor.dita#rreffuncfloor">FLOOR</xref></li>
 <li><xref href="rrefhourfunc.dita#rrefhourfunc"></xref></li>
 <li><xref href="rrefidentityvallocal.dita#rrefidentityvallocal"></xref></li>
 <li><xref href="rrefbuiltinteger.dita#rrefbuiltinteger"></xref></li>
 <li><xref href="rrefsqlj16762.dita#rrefsqlj16762"></xref></li>
+<li><xref href="rreffunclog.dita#rreffunclog">LN or LOG</xref></li>
+<li><xref href="rreffunclog10.dita#rreffunclog10">LOG10</xref></li>
 <li><xref href="rrefsqlj61998.dita#rrefsqlj61998"></xref></li>
 <li><xref href="rrefsqlj42049.dita#rrefsqlj42049"></xref></li>
 <li><xref href="rrefsqlj97870.dita#rrefsqlj97870"></xref></li>
 <li><xref href="rrefminutefunc.dita#rrefminutefunc"></xref></li>
 <li><xref href="rrefsqljmod.dita#rrefsqljmod"></xref></li>
 <li><xref href="rrefmonthfunc.dita#rrefmonthfunc"></xref></li>
+<li><xref href="rreffuncpi.dita#rreffuncpi">PI</xref></li>
+<li><xref href="rreffuncradians.dita#rreffuncradians">RADIANS</xref></li>
 <li><xref href="rrefsqlj32613.dita#rrefsqlj32613"></xref></li>
 <li><xref href="rrefsecondfunc.dita#rrefsecondfunc"></xref></li>
 <li><xref href="rrefsqlj25228.dita#rrefsqlj25228"></xref></li>
+<li><xref href="rreffuncsin.dita#rreffuncsin">SIN</xref></li>
 <li><xref href="rrefbuiltsmallint.dita#rrefbuiltsmallint"></xref></li>
 <li><xref href="rrefsqlj73147.dita#rrefsqlj73147"></xref></li>
 <li><xref href="rrefsqlj93082.dita#rrefsqlj93082"></xref></li>
+<li><xref href="rreffunctan.dita#rreffunctan">TAN</xref></li>
 <li><xref href="rreftimefunc.dita#rreftimefunc"></xref></li>
 <li><xref href="rreftimestampfunc.dita#rreftimestampfunc"></xref></li>
 <li><xref href="rrefsqlj29930.dita#rrefsqlj29930.dita"></xref></li>
@@ -61,4 +79,3 @@
 </ul></section>
 </refbody>
 </reference>
-