Re: Does XMLSERIALIZE output xmlattributes in a stable order?

On 11/21/2017 11:49 AM, Tom Lane wrote: > AFAICS, XMLSERIALIZE in our current implementation boils down to > being a binary-compatible coercion from XML (which is stored as > a string) to text. So the interesting question here is where are > you getting the XML values from? The stability of the

Re: Does XMLSERIALIZE output xmlattributes in a stable order?

Chapman Flack writes: > Suppose I have a query that generates some XML content, and I want > to do this on a periodic schedule and check the resulting XML into > a version control system. > ... > But then, there are the attributes of elements. Order of attributes > is not

Does XMLSERIALIZE output xmlattributes in a stable order?

Suppose I have a query that generates some XML content, and I want to do this on a periodic schedule and check the resulting XML into a version control system. To avoid spurious diffs, I know I can control the order of child elements generated by xmlagg by slipping an ORDER BY into the aggregate