From: | Jim Jones <jim(dot)jones(at)uni-muenster(dot)de> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Cc: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Subject: | Missing [NO] INDENT flag in XMLSerialize backward parsing |
Date: | 2025-02-20 13:27:42 |
Message-ID: | bebd457e-5b43-46b3-8fc6-f6a6509483ba@uni-muenster.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
This patch adds the missing [NO] INDENT flag to XMLSerialize backward
parsing. For example:
CREATE VIEW v1 AS
SELECT
xmlserialize(
DOCUMENT '<foo><bar>42</bar></foo>'::xml AS text
INDENT);
\sv v1
CREATE OR REPLACE VIEW public.v1 AS
SELECT XMLSERIALIZE(DOCUMENT '<foo><bar>42</bar></foo>'::xml AS
text INDENT) AS "xmlserialize"
SELECT * FROM v1;
xmlserialize
-----------------
<foo> +
<bar>42</bar>+
</foo>
(1 row)
The NO INDENT flag is added by default if no explicit indentation
flag was originally provided:
CREATE VIEW v2 AS
SELECT
xmlserialize(
DOCUMENT '<foo><bar>42</bar></foo>'::xml AS text
NO INDENT);
\sv v2
CREATE OR REPLACE VIEW public.v2 AS
SELECT XMLSERIALIZE(DOCUMENT '<foo><bar>42</bar></foo>'::xml AS text NO
INDENT) AS "xmlserialize"
CREATE VIEW v3 AS
SELECT
xmlserialize(
DOCUMENT '<foo><bar>42</bar></foo>'::xml AS text);
\sv v3
CREATE OR REPLACE VIEW public.v3 AS
SELECT XMLSERIALIZE(DOCUMENT '<foo><bar>42</bar></foo>'::xml AS text NO
INDENT) AS "xmlserialize"
Regression tests were updated accordingly.
Best regards, Jim
Attachment | Content-Type | Size |
---|---|---|
v1-0001-Fix-missing-NO-INDENT-flag-in-XMLSerialize-backwa.patch | text/x-patch | 9.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Mahendra Singh Thalor | 2025-02-20 13:49:27 | Re: Non-text mode for pg_dumpall |
Previous Message | Rahila Syed | 2025-02-20 13:26:49 | Re: Enhancing Memory Context Statistics Reporting |