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/5456~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/5456
Choose a head ref
  • 2 commits
  • 12 files changed
  • 2 contributors

Commits on Dec 12, 2025

  1. Add XMLNamespaces option to XMLElement 

    This patch adds support for the scoped option XMLNamespaces in
the XMLElement() function, as specified in ISO/IEC 9075-14:2023,
section 11.2, "XML lexically scoped options".

The XMLNamespaces clause allows users to declare XML namespace
prefixes and a default namespace within the scope of an XMLElement()
call. These declarations affect both the constructed element and
its content, enabling generation of namespaced XML content in a
standards-compliant way.

== Syntax ==

  xmlnamespaces(uri AS prefix, ...)
  xmlnamespaces(DEFAULT uri, ...)
  xmlnamespaces(NO DEFAULT, ...)

* prefix:         Namespace prefix to associate with the URI
* uri:            The namespace URI
* DEFAULT uri:    Specifies the default namespace within the scope
* NO DEFAULT:     Specifies that no default namespace is in effect

== Examples ==

  SELECT xmlelement(NAME "foo", xmlnamespaces('http:/x.y' AS bar));
  SELECT xmlelement(NAME "foo", xmlnamespaces(DEFAULT 'http:/x.y'));
  SELECT xmlelement(NAME "foo", xmlnamespaces(NO DEFAULT));

This feature enables standards-compliant construction of namespaced
XML directly from SQL, improving interoperability with XML-based
applications and document workflows.
    @jimjonesbr
    jimjonesbr authored and Commitfest Bot committed Dec 12, 2025
    Configuration menu
    Copy the full SHA
    2b6a42d View commit details
    Browse the repository at this point in the history

  2. [CF 5456] v11 - Add XMLNamespaces option to XMLElement 

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

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

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): Pavel Stehule, Jim Jones
    Commitfest Bot committed Dec 12, 2025
    Configuration menu
    Copy the full SHA
    85ddf12 View commit details
    Browse the repository at this point in the history
Loading