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. :)