On Wed, Aug 31, 2022 at 01:33:53PM -0400, Tom Lane wrote: > I did not check the other XMLTABLE infrastructure, so what probably > is best to do is keep the two output columns but change 'node()' > to something with a more stable result; any preferences?
The input object could also be reworked so as we would not have any ordering issues, say "<e>pre<f><g><n2>&deep</n2></g></f>post</e>". Changing only the path, you could use "/e/n2" instead of "node()", so as we'd always get the most internal member. -- Michael
signature.asc
Description: PGP signature