<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I believe oracle's implementation lets you do that, but its not
"standard".<br>
<br>
<br>
<pre class="moz-signature" cols="72">David A. Lee
<a class="moz-txt-link-abbreviated" href="mailto:dlee@calldei.com">dlee@calldei.com</a>
<a class="moz-txt-link-freetext" href="http://www.calldei.com">http://www.calldei.com</a>
<a class="moz-txt-link-freetext" href="http://www.xmlsh.org">http://www.xmlsh.org</a>
812-482-5224</pre>
<br>
<br>
Brian Maso wrote:
<blockquote
cite="mid:dcc7a340906151445obb3b04arabfc105116c7404c@mail.gmail.com"
type="cite">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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://en.wikipedia.org/wiki/SQL/XML" target="_blank">http://en.wikipedia.org/wiki/SQL/XML</a><br>
_______________________________________________<br>
<a moz-do-not-send="true" href="mailto:talk@x-query.com">talk@x-query.com</a><br>
<a moz-do-not-send="true"
href="http://x-query.com/mailman/listinfo/talk" target="_blank">http://x-query.com/mailman/listinfo/talk</a><br>
</blockquote>
</div>
<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
<a class="moz-txt-link-abbreviated" href="mailto:talk@x-query.com">talk@x-query.com</a>
<a class="moz-txt-link-freetext" href="http://x-query.com/mailman/listinfo/talk">http://x-query.com/mailman/listinfo/talk</a></pre>
</blockquote>
</body>
</html>