db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r446543 - /db/derby/docs/trunk/src/ref/rrefsqlj33562.dita
Date Fri, 15 Sep 2006 08:15:34 GMT
Author: kahatlen
Date: Fri Sep 15 01:15:33 2006
New Revision: 446543

URL: http://svn.apache.org/viewvc?view=rev&rev=446543
Log:
DERBY-1804: [DOC] CAST conversions between data types table is
incorrect in Reference manual in some VARCHAR and TIMESTAMP cases

Patch contributed by Laura Stewart.

Modified:
    db/derby/docs/trunk/src/ref/rrefsqlj33562.dita

Modified: db/derby/docs/trunk/src/ref/rrefsqlj33562.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj33562.dita?view=diff&rev=446543&r1=446542&r2=446543
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj33562.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj33562.dita Fri Sep 15 01:15:33 2006
@@ -35,11 +35,14 @@
 from which you are casting is the <i>source type</i>.</p> </refsyn>
 <section><title>CAST conversions among SQL-92 data types</title> <p>The
following
 table shows valid explicit conversions between source types and target types
-for SQL data types.   <table><title>Explicit conversions between source types
-and target types for SQL data types</title><desc>This table shows which explicit
-conversions between data types are valid. The first column on the table lists
-the source types, while the first row lists the target types. A "Y" indicates
-that the source to the target is a valid conversion.</desc>
+for SQL data types. This table shows which explicit conversions between data
+types are valid. The first column on the table lists the source data types.
+The first row lists the target data types. A "Y" indicates that a conversion
+from the source to the target is valid. For example, the first cell in the
+second row lists the source data type SMALLINT. The remaining cells on the
+second row indicate the whether or not you can convert SMALLINT to the target
+data types that are listed in the first row of the table.<table><title>Explicit
+conversions between source types and target types for SQL data types</title>
 <tgroup cols="20"><colspec colname="colspec0" colwidth="330*"/><colspec colname="col2"
 colwidth="84*"/><colspec colname="col3" colwidth="84*"/><colspec colname="col4"
 colwidth="84*"/><colspec colname="col5" colwidth="84*"/><colspec colname="col6"
@@ -562,7 +565,7 @@
 <entry colname="colspec10">-</entry>
 <entry colname="colspec13">Y</entry>
 <entry colname="colspec12">-</entry>
-<entry colname="colspec11">Y</entry>
+<entry colname="colspec11">-</entry>
 <entry colname="COLSPEC14">-</entry>
 </row>
 <row>
@@ -584,7 +587,7 @@
 <entry colname="colspec10">-</entry>
 <entry colname="colspec13">-</entry>
 <entry colname="colspec12">Y</entry>
-<entry colname="colspec11">Y</entry>
+<entry colname="colspec11">-</entry>
 <entry colname="COLSPEC14">-</entry>
 </row>
 <row>
@@ -638,13 +641,13 @@
 <section><title>Notes</title> <p>In this discussion, the <ph conref="refconrefs.dita#prod/productshortname"></ph>
SQL-92
 data types are categorized as follows:   <ul>
 <li><i>numeric</i>   <ul>
-<li>exact numeric (SMALLINT, INTEGER, BIGINT, DECIMAL, NUMERIC)</li>
-<li>approximate numeric (FLOAT, REAL, DOUBLE PRECISION)</li>
+<li>Exact numeric (SMALLINT, INTEGER, BIGINT, DECIMAL, NUMERIC)</li>
+<li>Approximate numeric (FLOAT, REAL, DOUBLE PRECISION)</li>
 </ul></li>
 <li><i>string</i>   <ul>
-<li>character string (CLOB, CHAR, VARCHAR, <xref href="rrefsqlj15147.dita#rrefsqlj15147">LONG
+<li>Character string (CLOB, CHAR, VARCHAR, <xref href="rrefsqlj15147.dita#rrefsqlj15147">LONG
 VARCHAR</xref>)</li>
-<li>bit string (BLOB, CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, <xref href="rrefsqlj30118.dita#rrefsqlj30118">LONG
+<li>Bit string (BLOB, CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, <xref href="rrefsqlj30118.dita#rrefsqlj30118">LONG
 VARCHAR FOR BIT DATA</xref>)</li>
 </ul></li>
 <li><i>date/time</i>   <ul>



Mime
View raw message