[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