My Postgre version its the 8.2. I´ve reached to do the path i wanted, but when i do a explain analyze on the select it return 500 miliseconds. Is this a good search? Is there a way to slow down this time with postgre 8.3? What is a good time for xml xpath´s?
Thanks
2008/1/8, x asasaxax <xanaruto@gmail.com>: Hi everyone,
I´m trying to undestand how to do select with xml path.
I have this xml example:
create table temp(id integer, xml text, Primary Key(id));
<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>
<element1>
<element2>
<element3 id="1" name="2">
<name></name>
<element4>
<element5></element5>
<element5></element5>
<element5></element5>
</element4>
</element3>
</element2>
</element1>
Here go the questions:
1) How can i select all name elements from the xml?
2) How can i select all element3 id´s?
3) How can i select all element5 that have element3 with attribute name="x"?
Thanks very much. :)