<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.17028"></HEAD>
<BODY
style="WORD-WRAP: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space">
<DIV dir=ltr align=left><FONT color=#0000ff size=2
face=Arial></FONT> </DIV>
<DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial> >> </FONT></SPAN>For now there's not way to set/get
this bit from userland,</DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial> >> </FONT></SPAN>ant it's current internal usage is
dedicated to SFCGAL stuff.</DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT><BR></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial> >> </FONT></SPAN>But you're right we could imagine
accessors to this SOLID bit,<BR></DIV></DIV>
<DIV><SPAN class=742324515-12072014></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>><SPAN
class=742324515-12072014> > </SPAN><SPAN
class=742324515-12072014> </SPAN></FONT></FONT></FONT>I
can see cases where people would have a closed surfce but would not want<BR>it
treated as a volume. (similar to closed linestring / polygon)</DIV><BR>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT><FONT color=#0000ff size=2
face=Arial></FONT><BR></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial> > </FONT></SPAN>Could you give us examples about this
?<SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial> </FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>Well
it depends how ST_3DIntersection and ST_3DIntersects behave. I haven't
exercised them enough with polyhedral surfaces to know.</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>Take a
building for example</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>You
may want the building structure to be treated as a hollow surface
kind of like a canvas around the building rather than a solid
building</FONT></SPAN><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial> so that when you ask if anything you are planning to put
in it</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>will
be obstructed, it will return false for
ST_3DIntersects.</FONT> </SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>Then
again I guess you could treat it as a solid with a hole and have a
slightly more complex geometry</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>than
you normally would. But I think in most cases its more efficient to treat
as a surface and ensure nothing is within X distance from the surface (or even a
surface that is slightly lower than the dimensions of the actual
building)</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>if you
are only concerned about things inside.</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>But in
some cases you might want it to be treated as a solid because it is a
volume blocked off that no object should penetrate -- like a Flight airspace
where if you are within that enclosed territory you are
screwed.</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>Then
again much of what I am saying I suppose could be handled if we had ST_3DCovers
and so forth operators.</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2 face=Arial>If the
SQL/MM specs haven't thought about it much maybe not too worthwhile to think
about right now.</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial>Regina</FONT></SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014> </SPAN></DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=742324515-12072014><FONT color=#0000ff size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT><FONT color=#0000ff size=2
face=Arial></FONT><BR></DIV><BR class=Apple-interchange-newline>
<BLOCKQUOTE type="cite">
<DIV><SPAN class=Apple-style-span
style="WHITE-SPACE: normal; BORDER-COLLAPSE: separate; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); FONT: medium Helvetica; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; TEXT-INDENT: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"><SPAN
class=Apple-style-span
style="WHITE-SPACE: normal; BORDER-COLLAPSE: separate; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); FONT: medium Helvetica; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; TEXT-INDENT: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"><SPAN
class=Apple-style-span
style="WHITE-SPACE: normal; BORDER-COLLAPSE: separate; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); FONT: medium Helvetica; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; TEXT-INDENT: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"><SPAN
class=Apple-style-span
style="WHITE-SPACE: normal; BORDER-COLLAPSE: separate; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); FONT: medium Helvetica; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; TEXT-INDENT: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"><SPAN
class=Apple-style-span
style="WHITE-SPACE: normal; BORDER-COLLAPSE: separate; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); FONT: medium Helvetica; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; TEXT-INDENT: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"><SPAN
class=Apple-style-span
style="WHITE-SPACE: normal; BORDER-COLLAPSE: separate; TEXT-TRANSFORM: none; WORD-SPACING: 0px; COLOR: rgb(0,0,0); FONT: medium Helvetica; ORPHANS: 2; WIDOWS: 2; LETTER-SPACING: normal; TEXT-INDENT: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px"><FONT
color=#0000ff size=2
face=Arial></FONT><BR> </DIV></BLOCKQUOTE></DIV></SPAN><BR
class=Apple-interchange-newline></SPAN><BR
class=Apple-interchange-newline></SPAN><BR
class=Apple-interchange-newline></SPAN><BR
class=Apple-interchange-newline></SPAN><BR
class=Apple-interchange-newline></SPAN><BR
class=Apple-interchange-newline><BR></BODY></HTML>