Re: XML path function

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(at)gmail(dot)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. :)
>