Re: Converting xml to table with optional elements
| От | David Johnston |
|---|---|
| Тема | Re: Converting xml to table with optional elements |
| Дата | |
| Msg-id | CAKFQuwa4Bxan4zjw9+ad1MK45PBsgMoq9RO2ve69_06yts_t3A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Converting xml to table with optional elements ("Andrus" <kobruleht2@hot.ee>) |
| Ответы |
Re: Converting xml to table with optional elements
|
| Список | pgsql-general |
Hi!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
UPDATE tbl SET ... = (SELECT xpath( tbl.???[...] ) 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.
David J.
В списке pgsql-general по дате отправления: