[postgis-devel] What's the difference between geom_accum and built in postgresql array_append

Kevin Neufeld kneufeld at refractions.net
Wed Aug 6 08:25:48 PDT 2008


I could be way off on this, but I suspect the reason is because it looks 
like array_append was introduced in PostgreSQL in 7.1, after or about 
the same time PostGIS was born.

-- Kevin

Obe, Regina wrote:
> I was trying to take a stab at understanding the postgis internal
> workings and one question that has always puzzled me is
> 
> Why are we using a postgis geom_accum function instead of the built in
> PostgreSQL array_append function to define our aggregates.  I did a
> couple of simple tests and the timings always seem pretty much exactly
> the same.
> 
> The only thought I could think of why this was done was
> 1) Its easier to debug the internal workings of the array
> 2) and its possible to internally throw PostGIS specific errors
> 
> Does that about sum it up or are there other reasons I am missing?
> 
> Thanks,
> Regina
> -----------------------------------------
> 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-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel



More information about the postgis-devel mailing list