2016-07-31 17:53 GMT+02:00 Tom Lane :
> Pavel Stehule writes:
> > The SQL/XML syntax is:
>
> > XMLTABLE (
> > xmlquery
> > PASSING xmldocument
> > [COLUMNS columns_list] )
>
> > columns_list := column_list ',' colname
>
> > colname := colname datatype [DEFAULT value] [PATH text]
>
> > The D
Pavel Stehule writes:
> The SQL/XML syntax is:
> XMLTABLE (
> xmlquery
> PASSING xmldocument
> [COLUMNS columns_list] )
> columns_list := column_list ',' colname
> colname := colname datatype [DEFAULT value] [PATH text]
> The DEFAULT clause is before PATH clause.
> A Oracle db uses litt
Hi
I am working on xmltable function. This function is used for simple data
extraction from XML documents. In this moment I am working on prototype's
parser.
The SQL/XML syntax is:
XMLTABLE (
xmlquery
PASSING xmldocument
[COLUMNS columns_list] )
columns_list := column_list ',' colname
co