[postgis-users] Difference between "Geometry" and "BLOB" in Postgis
    Sandro Santilli 
    strk at keybit.net
       
    Fri Oct 31 09:23:50 PDT 2014
    
    
  
On Fri, Oct 31, 2014 at 08:47:59AM -0400, Robert Burgholzer wrote:
> I am working through some postgis stuff for a Drupal module, and noticed
> that the geometry storage in Drupal is "bytea" (because it tends to be
> mysql-centric?).
> 
> What is the difference, i.e., advantage offered by the PostGIS custom type
> "geometry"?
Advantages are those of having typed data. Functions can behave differently
based on the data type, you can have type-specific statistical analyzers
and operators, you know exactly how to interpret the data...
--strk;
  ()   Free GIS & Flash consultant/developer
  /\   http://strk.keybit.net/services.html
    
    
More information about the postgis-users
mailing list