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