[postgis-users] Rounding off coordinates

Paul Ramsey pramsey at refractions.net
Mon Jun 28 08:50:38 PDT 2004


Gino,
Write up the function... base it on the parameters of the standard pgsql 
round function that Charlton has demonstrated below, it would be a 
useful addition.
Thanks!
Paul

Gino Lucrezi wrote:

>>new.lon := round(X(new.the_geom)::numeric,2);
>>new.lat := round(Y(new.the_geom)::numeric,2);
> 
> 
> This is simple if you're working with point data; but what if you're using any more complex data type, e.g. a line or a polygon? 
> :-(
> 
> Gino Lucrezi
> Penta Consulting Services Srl
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


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



More information about the postgis-users mailing list