From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: patch: function xmltable |
Date: | 2016-09-12 06:02:50 |
Message-ID: | CAFj8pRBTW7VTdYVpACOUsHA3GWy+8iU+_UutsbLMyLHgLoxTRQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
There is some opened questions - the standard (and some other databases)
requires entering XPath expression as string literal.
I am thinking so it is too strong not necessary limit - (it enforces
dynamic query in more cases), so I allowed the expressions there.
Another questions is when these expressions should be evaluated. There are
two possibilities - once per query, once per input row. I selected "once
per input row mode" - it is simpler to implement it, and it is consistent
with other "similar" generators - see the behave and related discussion to
"array_to_string" and evaluation of separator argument. The switch to "once
per query" should not be hard - but it can be strange for users, because
some his volatile expression should be stable.
Regards
Pavel
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2016-09-12 06:08:28 | Re: Project Policies |
Previous Message | Craig Ringer | 2016-09-12 06:02:33 | Re: patch: function xmltable |