Postgres Pro
Downloads
Home   >   mailing lists

Re: Converting xml to table with optional elements - Mailing list pgsql-general

From Andrus
Subject Re: Converting xml to table with optional elements
Date
Msg-id 203BD69201BA441DAFD612CBB2777EA8@dell2
Whole thread Raw
In response to Re: Converting xml to table with optional elements  (David Johnston <david.g.johnston@gmail.com>)
Responses Re: Converting xml to table with optional elements
List pgsql-general
Tree view
Hi!
 
Thank you.
>Subquery the xpath expression to unnest it and apply a LIMIT 1
> UPDATE tbl SET ... = (SELECT xpath( tbl.???[...] ) LIMIT 1)
 
I used unnest() :
 
update temprid set
  ContactFirstName =unnest(xpath(
     '/E-Document/Document/DocumentParties/BuyerParty/ContactData/ContactFirstName/text()',x))::text
 
Is this OK ?
 
 
>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.
 
How to create table of documents ?
 
xml contains multiple products and document info.
Code creates table containing one row for every product and adds same header fields to all rows.
Whu this will not work ?
 
Andrus.
 

pgsql-general by date:

Previous
From: Misa Simic
Date:
Subject: Re: PG94RC1- plv8 functions - problem with input parameter length
Next
From: David Johnston
Date:
Subject: Re: Converting xml to table with optional elements