You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by jh...@apache.org on 2016/10/28 02:22:05 UTC
svn commit: r1766916 - in /calcite/site: community/index.html
docs/reference.html
Author: jhyde
Date: Fri Oct 28 02:22:04 2016
New Revision: 1766916
URL: http://svn.apache.org/viewvc?rev=1766916&view=rev
Log:
Change PMC chair
Modified:
calcite/site/community/index.html
calcite/site/docs/reference.html
Modified: calcite/site/community/index.html
URL: http://svn.apache.org/viewvc/calcite/site/community/index.html?rev=1766916&r1=1766915&r2=1766916&view=diff
==============================================================================
--- calcite/site/community/index.html (original)
+++ calcite/site/community/index.html Fri Oct 28 02:22:04 2016
@@ -159,7 +159,7 @@
<td style="text-align: left">Jesús Camacho Rodríguez (<a href="http://people.apache.org/phonebook.html?uid=jcamacho">jcamacho</a>)</td>
<td style="text-align: left"><a href="http://github.com/jcamachor"><img width="64" src="http://github.com/jcamachor.png" /></a></td>
<td style="text-align: left">Hortonworks</td>
- <td style="text-align: left">PMC</td>
+ <td style="text-align: left">PMC Chair</td>
</tr>
<tr>
<td style="text-align: left">Jinfeng Ni (<a href="http://people.apache.org/phonebook.html?uid=jni">jni</a>)</td>
@@ -183,7 +183,7 @@
<td style="text-align: left"><a href="http://people.apache.org/~jhyde">Julian Hyde</a> (<a href="http://people.apache.org/phonebook.html?uid=jhyde">jhyde</a>)</td>
<td style="text-align: left"><a href="http://github.com/julianhyde"><img width="64" src="http://github.com/julianhyde.png" /></a></td>
<td style="text-align: left">Hortonworks</td>
- <td style="text-align: left">PMC Chair</td>
+ <td style="text-align: left">PMC</td>
</tr>
<tr>
<td style="text-align: left">Maryann Xue (<a href="http://people.apache.org/phonebook.html?uid=maryannxue">maryannxue</a>)</td>
Modified: calcite/site/docs/reference.html
URL: http://svn.apache.org/viewvc/calcite/site/docs/reference.html?rev=1766916&r1=1766915&r2=1766916&view=diff
==============================================================================
--- calcite/site/docs/reference.html (original)
+++ calcite/site/docs/reference.html Fri Oct 28 02:22:04 2016
@@ -1507,6 +1507,43 @@ SPECIFIC_NAME,
<strong>SQLEXCEPTION</strong>,
<strong>SQLSTATE</strong>,
<strong>SQLWARNING</strong>,
+SQL_BIGINT,
+SQL_BINARY,
+SQL_BIT,
+SQL_BLOB,
+SQL_BOOLEAN,
+SQL_CHAR,
+SQL_CLOB,
+SQL_DATE,
+SQL_DECIMAL,
+SQL_DOUBLE,
+SQL_FLOAT,
+SQL_INTEGER,
+SQL_INTERVAL_DAY,
+SQL_INTERVAL_DAY_TO_HOUR,
+SQL_INTERVAL_DAY_TO_MINUTE,
+SQL_INTERVAL_DAY_TO_SECOND,
+SQL_INTERVAL_HOUR,
+SQL_INTERVAL_HOUR_TO_MINUTE,
+SQL_INTERVAL_HOUR_TO_SECOND,
+SQL_INTERVAL_MINUTE,
+SQL_INTERVAL_MINUTE_TO_SECOND,
+SQL_INTERVAL_MONTH,
+SQL_INTERVAL_SECOND,
+SQL_INTERVAL_YEAR,
+SQL_INTERVAL_YEAR_TO_MONTH,
+SQL_LONGVARBINARY,
+SQL_LONGVARCHAR,
+SQL_LONGVARNCHAR,
+SQL_NCHAR,
+SQL_NCLOB,
+SQL_NUMERIC,
+SQL_NVARCHAR,
+SQL_REAL,
+SQL_SMALLINT,
+SQL_TIME,
+SQL_TIMESTAMP,
+SQL_TINYINT,
SQL_TSI_DAY,
SQL_TSI_FRAC_SECOND,
SQL_TSI_HOUR,
@@ -1517,6 +1554,8 @@ SQL_TSI_QUARTER,
SQL_TSI_SECOND,
SQL_TSI_WEEK,
SQL_TSI_YEAR,
+SQL_VARBINARY,
+SQL_VARCHAR,
<strong>SQRT</strong>,
<strong>START</strong>,
STATE,
@@ -2580,9 +2619,25 @@ the user or application to supply a time
<li>{fn DATABASE()}</li>
<li>{fn IFNULL(value, value)}</li>
<li>{fn USER(value, value)}</li>
- <li>{fn CONVERT(value, type)}</li>
</ul>
+<h4 id="conversion">Conversion</h4>
+
+<table>
+ <thead>
+ <tr>
+ <th style="text-align: left">Operator syntax</th>
+ <th style="text-align: left">Description</th>
+ </tr>
+ </thead>
+ <tbody>
+ <tr>
+ <td style="text-align: left">{fn CONVERT(value, type)}</td>
+ <td style="text-align: left">Cast <em>value</em> into <em>type</em></td>
+ </tr>
+ </tbody>
+</table>
+
<h3 id="aggregate-functions">Aggregate functions</h3>
<p>Syntax:</p>