Thread: maybe buggy implementation of NO INDENT in xmlserialize

maybe buggy implementation of NO INDENT in xmlserialize

From
Pavel Stehule
Date:
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