Re: patch: function xmltable
Pavel Stehule <pavel.stehule@gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
To: Craig Ringer <craig@2ndquadrant.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2016-09-23T20:22:02Z
Lists: pgsql-hackers
Hi 2016-09-23 10:07 GMT+02:00 Craig Ringer <craig@2ndquadrant.com>: > > Did some docs copy-editing and integrated some examples. > > Whoops, forgot to attach. > > Rather than sending a whole new copy of the patch, here's a diff > against your patched tree of my changes so you can see what I've done > and apply the parts you want. > > Note that I didn't updated the expected files. > I applied your patch - there is small misunderstanding. The PATH is evaluated once for input row already. It is not clean in code, because it is executor node started and running for all rows. I changed it in your part of doc. to a simple value before calling the function. <literal>PATH</> + expressions are normally evaluated <emphasis>exactly once per result row ## per input row + </emphasis>, Regards Pavel > > -- > Craig Ringer http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services >
Commits
-
Support XMLTABLE query expression
- fcec6caafa23 10.0 landed
-
Create <sect3> in the functions-xml section
- 4461a9bfd1ac 10.0 landed
-
Improve handling of "UPDATE ... SET (column_list) = row_constructor".
- 906bfcad7ba7 10.0 cited
-
Add xmlexists function
- 641459f26954 9.1.0 cited