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 <[EMAIL PROTECTED]>: > > 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. :) >
