Yea, I knew about SQL/XML. I was thinking more about intra-column indexing -- so if I have an XML column I could write an efficient WHERE clause on the value of a specific descendant element value. I don't believe SQL/XML defines a way to ddefine indexes using, say, an XPath expression.<br>
<br>Best regards,<br>Brian Maso<br><br><div class="gmail_quote">On Mon, Jun 15, 2009 at 2:19 PM, Pavel Minaev <span dir="ltr"><<a href="mailto:int19h@gmail.com">int19h@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Mon, Jun 15, 2009 at 2:10 PM, Brian Maso<<a href="mailto:brian@blumenfeld-maso.com">brian@blumenfeld-maso.com</a>> wrote:<br>
> I had heard that future versions of the SQL standard are to bring XML in to<br>
> SQL -- basically make non-validated XML nodes as valid column types and add<br>
> intra-XML indexing.<br>
<br>
It's called SQL/XML, and it has been there since SQL-2003:<br>
<br>
<a href="http://en.wikipedia.org/wiki/SQL/XML" target="_blank">http://en.wikipedia.org/wiki/SQL/XML</a><br>
_______________________________________________<br>
<a href="mailto:talk@x-query.com">talk@x-query.com</a><br>
<a href="http://x-query.com/mailman/listinfo/talk" target="_blank">http://x-query.com/mailman/listinfo/talk</a><br>
</blockquote></div><br>