You have to process this in two passes. First pass you create a table of documents by unnesting the non-optional >Document elements. Second pass you explode each individual row/document on that table into its components.
Thank you. I tried code below. John Smith appears in result as "{"John Smith"}" How to force it to appear as John Smith ?
Subquery the xpath expression to unnest it and apply a LIMIT 1
This will cause either the first array element or NULL set to be the given column's value.
Note that I do not believe your example code is going to work. As I mentioned you really want to create a table of documents and NOT try to pair up multiple unnested columns.
