Re: Converting xml to table with optional elements

[David Johnston <david.g.johnston@xxxxxxxxx>]

On Fri, Nov 28, 2014 at 10:47 AM, Andrus <kobruleht2@xxxxxx> wrote:

Hi!

Thank you.

Instead of defining an xpath for fields define one that captures the xml pertaining to the data that would belong to
a single record.How to create single xpath or xsl which assigns values to all columns in Postgres table ?

I havent found such sample. Samples which I have found create every column separately using separate xpath.

I don't know - I'm not a heavy user of xpath/xml.  I do know that "text()" will not be of help because you have to return an entire node - xml elements included.  The textual representation of that node is then to be stored and all the extraction xpath _expression_ executed against it.

David J.

​