[postgis-devel] Specifying end cap and join styles Buffer op

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Mon Jun 22 05:29:03 PDT 2009


strk wrote:

> Paul and me excercised a bit in inputing SQL and found arrays
> being less comfortable than a plain string.
> 
> Compare:
> 
> 	st_buffer(geom, 10, 'join=bevel endcap=flat limit=10');
> with:
> 	st_buffer(geom, 10, '{{"join", bevel"},{"endcap","flat"},{"limit","10"}}');
> 
> (pretty sure the first one I typed it correctly, should check for the second)
> 
> --strk;

I see, although I actually had in mind using the standard array 
constructor maybe something like this:


select st_buffer(geom, 10, array['join=bevel', 'endcap=flat', 'limit=10']);


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063



More information about the postgis-devel mailing list