You couldn't have said better what I meant. I store the xml already parsed. You can navigate right along. To the parent, the previous, the next elemnt or the first or last child.
Which is the whole point of indexing it...
I use XML a lot for all sorts of purposes, but it is appropriate for data transfer rather than data storage, IMNSHO.
Right now, you're quite right. But I want to change that.
No point, it's a data exchange format, it's not usefull for data storage.
Chris
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
