<HTML dir=ltr><HEAD><TITLE>Re: [postgis-users] ST_<function> vs <function></TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR></HEAD>
<BODY><XMP>
Sehr geehrter Absender,
vielen Dank für Ihre Email.
Leider kann ich Ihre Nachricht im Moment nicht persönlich
beantworten, da ich mich bis zum 21.09.2007 im Urlaub befinden.
Nach meiner Rückkehr am 24.09.2007 werde ich gerne Ihre Anfrage beantworten.
Bitte wenden Sie sich in dringenden Fällen an Herrn Jens Schwarz, jens.schwarz@alpstein.de oder per Telefon 08323-8006-0.
Mit freundlichen Grüßen
Hubert Burger
Alpstein GmbH
Missener Str. 18
87509 Immenstadt
fon +49 8323 8006-0
fax +49 8323 8006-50
web www.alpstein.de
</XMP>
<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>