[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