postgres xpath all nodes and use function on few of them

Question

I have a problem with writing a function in postgresql that gets input with xml data, then gets all nodes and for nodes that ends with work 'key' calls a function. In example i have to do:

function readdata(data xml) RETURNS VOID AS $$
INSERT INTO data_table SELECT FROM xpath('//text()',data)

Some of xml is like:

< node1>sometext< /node1>
< node2_key>anyvalue< /node2_key>
< node3_key>integer< /node3_key>
< node4>anyvalue< /node4>

But i dont know how to call function like check_val('node2',valueof node2_key ) when selecting from data parameter.

What im trying to achive is: that in my SELECT in myfunction it gives me value of nodes when they don't end up with word 'key',and for nodes that ends with it gives me result of check_val function.

Is there a way to do it with postgresql 9.1? I would be grateful with any example of code.

MiMo · Accepted Answer · 2012-05-25 15:16:31Z

1

I don't know about Postgres, but the XPath to get the text of all the nodes (elements) whose name ends with key is:

//*[string-length(name())>2 and substring(name(),string-length(name())-2,3)='key']/text()

and the XPath to get the text of all the nodes (elements) whose names do NOT end with key is:

//*[string-length(name())<3 or substring(name(),string-length(name())-2,3)!='key']/text()

answered May 25, 2012 at 15:16

MiMo

12k1 gold badge35 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Axxxon Over a year ago

thats not what i meant exacly, i want to have in output something like SELECT node1_value,check_val('node2',valueof node2_key ),check_val('node3',valueof node3_key ), node4_value

Collectives™ on Stack Overflow

postgres xpath all nodes and use function on few of them

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related