Re: patch: function xmltable
Alvaro Herrera <alvherre@2ndquadrant.com>
From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Craig Ringer <craig@2ndquadrant.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2016-12-07T07:14:39Z
Lists: pgsql-hackers
Attachments
- xmltable-21.patch (text/plain) patch
- xmltable-21.patch (text/plain) patch
Here's v21. * I changed the grammar by moving the NOT NULL to the column options, and removing the IsNotNull production. It wasn't nice that "NOT NULL DEFAULT 0" was not accepted, which it is with the new representation. * The tuple that's returned is natively a TupleTableSlot inside the table builder, not directly a HeapTuple. That stuff was ugly and wasn't using the proper abstraction anyway. * I changed the signatures of the methods so that they receive TableExprState, and restructured the "opaque" data to be inside TableExprState. Now we don't need to have things such as the tupdesc or the input functions be repeated in the opaque struct. Instead they belong to the TableExprState and the methods can read them from there. I managed to break the case with no COLUMNS. Probably related to the tupdesc changes. It now crashes the regression test. Too tired to debug now; care to take a look? The other stuff seems to run fine, though of course the regression test crashes in the middle, so perhaps there are other problems. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, 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