Author: shawkins
Date: 2010-08-16 16:06:21 -0400 (Mon, 16 Aug 2010)
New Revision: 2466
Modified:
trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml
Log:
updating the xmltable example
Modified: trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml
===================================================================
---
trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-08-16
17:58:22 UTC (rev 2465)
+++
trunk/documentation/reference/src/main/docbook/en-US/content/sql_support.xml 2010-08-16
20:06:21 UTC (rev 2466)
@@ -914,7 +914,7 @@
<itemizedlist>
<para>Examples</para>
<listitem>
- <para>Use of passing, returns 1 row [1]: <programlisting>select *
from xmltable('/a' PASSING {x '<a id="1"/>'}
COLUMNS id integer PATH '@id') x</programlisting>
+ <para>Use of passing, returns 1 row [1]: <programlisting>select *
from xmltable('/a' PASSING xmlparse(document '<a
id="1"/>') COLUMNS id integer PATH '@id')
x</programlisting>
</para>
</listitem>
<listitem>
Show replies by date