Mark Birbeck wrote:
>We use a simple technique where we have a table for attributes and a
>table for elements. The attribute table has a join on the element table
>to say what element the attribute belongs to, whilst the element has
>joins to itself to say who the parent of an element is. This allows us
>to store an object-like tree structure, and so generate XML documents
>from any point in the tree.
Can you help this relational newbie understand the following:
I can see how you could build a tree out of element content very easily. But
what about mixed content?
How do you do a join on XML data that looks like this:
<element>This is #PCDATA<mixed>with mixed content</mixed>and an element
Thanks in advance.
Software Performance Systems