<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=196301211-01082008><FONT face=Arial
color=#0000ff size=2>Erik,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=196301211-01082008><FONT face=Arial
color=#0000ff size=2>How were you using ST_Union and what exactly do you mean by
no result. no result as it looks blank? If you are using something
like PgAdmin III - it will look blank because it exceeds the buffer supported by
PgAdmin III.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=196301211-01082008><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=196301211-01082008><FONT face=Arial
color=#0000ff size=2>SELECT the_geom is null </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=196301211-01082008><FONT face=Arial
color=#0000ff size=2>FROM (somequery or table) as foo</FONT></SPAN></DIV>
<DIV><SPAN class=196301211-01082008><FONT face=Arial color=#0000ff size=2>LIMIT
1</FONT></SPAN></DIV>
<DIV><SPAN class=196301211-01082008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=196301211-01082008><FONT face=Arial color=#0000ff size=2>will
tell you if its actually returning no geometry</FONT></SPAN></DIV>
<DIV><SPAN class=196301211-01082008><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=196301211-01082008><FONT face=Arial color=#0000ff size=2>Hope
that helps,</FONT></SPAN></DIV>
<DIV><SPAN class=196301211-01082008><FONT face=Arial color=#0000ff
size=2>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>danny<BR><B>Sent:</B> Friday, August 01, 2008 6:12 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] Merge
all polygons from a dataset<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>Hello everybody,<BR><BR>I've converted a shapefile of Europe to
PostGIS. I would like to merge all the countries together so that I only have
one polygon left, the whole contour of Europe. I have tried ST_Union that gives
me no result. I've tried several other functions to no avail. Does anybody know
how I should proceed?<BR><BR>Many thanks,<BR><BR>Erik<BR></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>