[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Rounding off coordinates
From:       Paul Ramsey <pramsey () refractions ! net>
Date:       2004-06-28 15:50:38
Message-ID: 40E03E4E.4050103 () refractions ! net
[Download RAW message or body]

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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


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


[prev in list] [next in list] [prev in thread] [next in thread]