Re: [HACKERS] xmltable doc fix and example for XMLNAMESPACES

[Alvaro Herrera]

Pavel Stehule wrote:
> Hi
> 
> I am sending a patch with changes in XMLTABLE documentation proposed by
> Arjen.

Thanks, pushed with some rewording.

-- 
Álvaro Herrerahttps://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] xmltable doc fix and example for XMLNAMESPACES

[Pavel Stehule]

Hi

I am sending a patch with changes in XMLTABLE documentation proposed by
Arjen.

Regards

Pavel
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index ba6f8dd8d2..857c56241b 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -10504,7 +10504,7 @@ SELECT xpath_exists('/my:a/text()', 'http://example.com;>test
 
 
-xmltable( XMLNAMESPACES(namespace uri AS namespace name, ...)
+xmltable( XMLNAMESPACES(namespace uri AS namespace name, ...), 
   row_expression PASSING BY REF document_expression BY REF
   COLUMNS name { type PATH column_expression DEFAULT default_expression NOT NULL | NULL
 | FOR ORDINALITY }
@@ -10689,6 +10689,34 @@ SELECT xmltable.*
Hello2a2   bbbCC  
 ]]>
 
+
+
+ Inside clause XMLNAMESPACES we can specify list of namespaces
+ used in XML document:
+
+  
+

   
 

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers