maybe buggy implementation of NO INDENT in xmlserialize - Mailing list pgsql-hackers

From Pavel Stehule
Subject maybe buggy implementation of NO INDENT in xmlserialize
Date
Msg-id CAFj8pRAhZqN=WzNHKNid-6usE_qnuwbBfGrq8+pS644zEURPBA@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Hi

I checked our implementation of xmlserialize, and it looks like there are few issues.

1. It doesn't conform to SQL/XML - there is some overlap with the proposed CANONICAL flag, but not full.

2. There is significantly different behaviour of NO INDENT on Oracle and other db, that implements it. It really removes indentation from XML.

3. Oracle doesn't conform SQL/XML too fully. SQL/XML knows two states "INDENT" x "NO INDENT". Oracle has three states: indeterminate (default), INDENT and NO INDENT. Probably, Oracle's default (INDENT or NO INDENT) is not the same as PostgreSQL default (without change of formatting).

Has somebody an idea, what should be expected behaviour?

Regards

Pavel

pgsql-hackers by date:

Previous
From: Nisha Moond
Date:
Subject: Re: Conflict Detection and Resolution
Next
From: Thomas Munro
Date:
Subject: Re: macOS prefetching support