subject:"\[HACKERS\] Syntax of xmltable function"

Re: [HACKERS] Syntax of xmltable function

2016-08-01 Thread Pavel Stehule

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

Re: [HACKERS] Syntax of xmltable function

2016-07-31 Thread 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 DEFAULT clause is before PATH

[HACKERS] Syntax of xmltable function

2016-07-31 Thread Pavel Stehule

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