[postgis] distance(geometry,geometry) function

[Paul Ramsey]

> The PostGIS geometry type is different from the standard PostgreSQL
> geometry types in that (1) we support 3D (2) indexing on all types (3)
> more advanced geometries (like polygons with holes) (4) collection-type
> geometries (multi* and geometrycollection) and (5) no size limit.

And (6) support functions to make them actually useful in a GIS context.
The PostgreSQL base geometric types have been essentially rotting: none
of the core pgsql developers has a particular interest in supporting or
enhancing their use. We could have done support functionality against
the base types, but would then have been missing, as Dave notes, 3D,
holes, aggregates, indexing.  Most importantly, we would have been
unable to exceed the page size limit (8Kb) for a given feature if we
used the base types.

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_

------------------------ Yahoo! Groups Sponsor ---------------------~-->
Small business owners...
Tell us what you think! http://promo2.yahoo.com/sbin/Yahoo!_BusinessNewsletter/survey.cgi
http://us.click.yahoo.com/vO1FAB/txzCAA/ySSFAA/PhFolB/TM
---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/