Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/5431~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/5431
Choose a head ref
  • 2 commits
  • 8 files changed
  • 2 contributors

Commits on Apr 29, 2025

  1. Add XMLDocument function (SQL/XML X030) 

    This patch adds the SQL/XML X030 function XMLDocument. It returns
an XML document from a given XML expression. An XML document node
can have any number of children nodes. Since our XML data type
corresponds to XML(CONTENT(ANY)), any expression already validated
by the input function is considered valid output for XMLDocument.
As a result, this function simply returns its input value. While
this implementation is quite trivial, it follows the SQL/XML
standard and facilitates the migration of SQL statements from
other database systems that also support X030.

Usage:

WITH t(x) AS (
  VALUES
    (xmlparse(DOCUMENT '<root><foo>bar</foo></root>')),
    (xmlforest(42 AS foo, 73 AS bar)),
    (NULL)
)
SELECT xmldocument(x) FROM t;

         xmldocument
-----------------------------
 <root><foo>bar</foo></root>
 <foo>42</foo><bar>73</bar>

(3 rows)

This patch also adds documentation and tests.
    @jimjonesbr
    jimjonesbr authored and Commitfest Bot committed Apr 29, 2025
    Configuration menu
    Copy the full SHA
    9629b26 View commit details
    Browse the repository at this point in the history

  2. [CF 5431] v8 - Add XMLDocument (SQL/XML X030) 

    This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/5431

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/[email protected]
Author(s): Jim Jones
    Commitfest Bot committed Apr 29, 2025
    Configuration menu
    Copy the full SHA
    2e1365a View commit details
    Browse the repository at this point in the history
Loading