<html>

<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:"Book Antiqua";
        panose-1:2 4 6 2 5 3 5 3 3 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0pt;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {font-family:Arial;
        color:windowtext;}
@page Section1
        {size:612.0pt 792.0pt;
        margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink=purple>

<div class=Section1>

<p class=MsoNormal><b><font size=2 face="Book Antiqua"><span style='font-size:
10.0pt;font-family:"Book Antiqua";font-weight:bold'>All,</span></font></b></p>

<p class=MsoNormal><b><font size=2 face="Book Antiqua"><span style='font-size:
10.0pt;font-family:"Book Antiqua";font-weight:bold'> </span></font></b></p>

<p class=MsoNormal><b><font size=2 face="Book Antiqua"><span style='font-size:
10.0pt;font-family:"Book Antiqua";font-weight:bold'>I would appreciate help in
constructing an SQL statement that performs a difference function on two
datasets. My intersect function works but cannot work out the kinks with
st_difference. Thanks for your help…Im new to Postgis. </span></font></b></p>

<p class=MsoNormal><b><font size=2 face="Book Antiqua"><span style='font-size:
10.0pt;font-family:"Book Antiqua";font-weight:bold'> </span></font></b></p>

<p class=MsoNormal><b><font size=2 face="Book Antiqua"><span style='font-size:
10.0pt;font-family:"Book Antiqua";font-weight:bold'>Rich</span></font></b></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> </span></font></p>

</div>

</body>

</html>