<!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><SPAN class=863293421-21082007><FONT face=Arial size=2>I just installed the
new version of 1.3.1 and noticed something which I'm not sure was intended or
not or if something went amiss with my upgrade.</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>Before there used to
be 2 formats of collect</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>That which takes two
geometries used like so - which I see has an alias
st_collect</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>st_collect(geom1,
geom2)</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>and there was
another variant of collect which is used as an aggregate
function</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>SELECT
collect(geom)</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>FROM
sometable</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>GROUP BY
somefield</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>In my version the
old collect aggregate function does not seem to have been aliased as well to
st_collect.</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>E.g.
doing</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>SELECT
st_collect(geom)</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>FROM
sometable</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>GROUP BY somefield
</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>gives me an
error while the old </FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>SELECT
collect(geom)</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>FROM
sometable</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>GROUP BY somefield
</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007>still
works.</SPAN></DIV></FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>I have the same
issue with geomunion vs. st_geomunion</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial size=2>Am I missing
something?</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=863293421-21082007><FONT face=Arial
size=2>Regina</FONT></SPAN></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>