XML path function

From: "x asasaxax" <xanaruto(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: XML path function
Date: 2008-01-08 20:21:41
Message-ID: 91495cb0801081221g41e91241v34537eec25b056e8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message D. Dante Lorenso 2008-01-08 22:41:09 WHERE vs ORDER BY vs LIMIT why not using the correct index?
Previous Message David Fetter 2008-01-08 19:25:45 Re: XML and Routing