<HTML dir=ltr><HEAD><TITLE>Re: [postgis-users] ST_<function> vs <function></TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText12885 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Steve,</FONT></DIV>
<DIV dir=ltr> </DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Just to add to what Mark said. There is a little bit more going on than simply a renaming.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Most if not all of the ST relation functions have automatic index use enabled in them.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>For example</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>the old within is really closer to the hidden _ST_Within and the new </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>ST_Within function is equivalent to writing the old </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>geom1 && geom2 AND Within(geom1, geom2) </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Same goes for ST_Contains, ST_Overlap etc.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Hope that helps,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>Regina</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> postgis-users-bounces@postgis.refractions.net on behalf of Mark Cave-Ayland<BR><B>Sent:</B> Sun 9/9/2007 4:30 PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] ST_<function> vs <function><BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>On Sun, 2007-09-09 at 16:03 -0400, Stephen Woodbridge wrote:<BR>> Hi all,<BR>><BR>> I seem to have missed reading some vital post or something.<BR>><BR>> What is the difference between ST_<function>() and <function>()?<BR>> Is this just a renaming for namespace issues?<BR>> Are the <function>() names deprecated?<BR>> Are there other benefits to this renaming?<BR>><BR>> Please explain or point me to the relevant docs.<BR>><BR>> Thanks,<BR>> -Steve<BR><BR><BR>Hi Stephen,<BR><BR>I don't remember there being much discussion about this, but the<BR>relevant commit can be found here:<BR><A href="http://postgis.refractions.net/pipermail/postgis-commits/2007-June/000074.html">http://postgis.refractions.net/pipermail/postgis-commits/2007-June/000074.html</A>. In short, the old function names are deprecated, and new applications should start to use the ST_ prefix functions instead.<BR><BR><BR>ATB,<BR><BR>Mark.<BR><BR>--<BR>ILande - Open Source Consultancy<BR><A href="http://www.ilande.co.uk/">http://www.ilande.co.uk</A><BR><BR><BR>_______________________________________________<BR>postgis-users mailing list<BR>postgis-users@postgis.refractions.net<BR><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></FONT></P></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>