Thread: XML

If I wanted to store the below XML in a text field, would I be able to
insert additional attributes, and/or be able to substitute the id of the
inner g tag when querying it from the database.  For example:

From:
<g id="myGtag>
    <g id="myGtag2">
    <\g>
<\g>

To:
<g id="myGtag>
    <g id="Button1a" onClick="click1();" >
    <\g>
<\g>

Thanks.

Sean.

On Jul 18, 2005, at 6:19 PM, Sean Montague wrote:

> If I wanted to store the below XML in a text field, would I be able to
> insert additional attributes, and/or be able to substitute the id of
> the inner g tag when querying it from the database.  For example:
>
> From:
> <g id="myGtag>
>    <g id="myGtag2">
>    <\g>
> <\g>
>
> To:
> <g id="myGtag>
>    <g id="Button1a" onClick="click1();" >
>    <\g>
> <\g>

You might want to look at contrib/xml2 in the distribution (assuming
8.x).

Here are a couple of links:
http://www.throwingbeans.org/tech/postgresql_and_xml.html
http://www.throwingbeans.org/postgresql_and_xml_updated.html

Sean