[postgis-users] ST_<function> vs <function>
Barend K=?ISO-8859-1?B?9g==?=bben
kobben at itc.nl
Mon Sep 10 23:25:46 PDT 2007
The SQL-MM specification has ST_ as a prefix to all spatial funcionality
(types, functions), and the newer PostGIS functions will follow that spec...
On 11-09-2007 02:42, "Stephen Woodbridge" <woodbri at swoodbridge.com> wrote:
> This is all I could find:
>
> Log:
> Added versions of functions with standard ST (Spatial Type) prefixes to
> any functions that were lacking them. Updated the regression tests to
> include the new functions.
>
>
> Richard Greenwood wrote:
>> I'm embarrassed to ask, but what does "ST" stand for?
>>
>> Rich
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On 9/10/07, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
>>>
>>>
>>> Steve,
>>>
>>> Just to add to what Mark said. There is a little bit more going on than
>>> simply a renaming.
>>>
>>> Most if not all of the ST relation functions have automatic index use
>>> enabled in them.
>>>
>>> For example
>>>
>>> the old within is really closer to the hidden _ST_Within and the new
>>> ST_Within function is equivalent to writing the old
>>>
>>> geom1 && geom2 AND Within(geom1, geom2)
>>>
>>> Same goes for ST_Contains, ST_Overlap etc.
>>>
>>> Hope that helps,
>>> Regina
>>>
>>> ________________________________
>>> From: postgis-users-bounces at postgis.refractions.net on
>>> behalf of Mark Cave-Ayland
>>> Sent: Sun 9/9/2007 4:30 PM
>>> To: PostGIS Users Discussion
>>> Subject: Re: [postgis-users] ST_<function> vs <function>
>>>
>>>
>>>
>>>
>>> On Sun, 2007-09-09 at 16:03 -0400, Stephen Woodbridge wrote:
>>>> Hi all,
>>>>
>>>> I seem to have missed reading some vital post or something.
>>>>
>>>> What is the difference between ST_<function>() and <function>()?
>>>> Is this just a renaming for namespace issues?
>>>> Are the <function>() names deprecated?
>>>> Are there other benefits to this renaming?
>>>>
>>>> Please explain or point me to the relevant docs.
>>>>
>>>> Thanks,
>>>> -Steve
>>>
>>> Hi Stephen,
>>>
>>> I don't remember there being much discussion about this, but the
>>> relevant commit can be found here:
>>> http://postgis.refractions.net/pipermail/postgis-commits/2007-June/000074.ht
>>> ml.
>>> In short, the old function names are deprecated, and new applications should
>>> start to use the ST_ prefix functions instead.
>>>
>>>
>>> ATB,
>>>
>>> Mark.
>>>
>>> --
>>> ILande - Open Source Consultancy
>>> http://www.ilande.co.uk
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>>
>>> ________________________________
>>>
>>>
>>>
>>>
>>> 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.
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list