[postgis-users] precision on intersection results

[TECHER David]

Hi Toni

Select Cast(Intersection(a.the_geom,b.the_geom) as decimal(15,3)) from
your_fisrt_table a, your_second_table b where ...

toni hernández a écrit :

> hi,
>
> When I run the intersection function between two LINESTRINGS I obtain
> something like 456789.345782323. It is 9 decimals.
>
> Is there a way to tell postgis to cut the number of decimals so the
> result of intersecting the same two lines was, for example, 456789.345?
>
> thanks in advance
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
--david;
http://www.postgis.fr
http://www.davidgis.fr


	

	
		
___________________________________________________________________________ 
Découvrez un nouveau moyen de poser toutes vos questions quelque soit le sujet ! 
Yahoo! Questions/Réponses pour partager vos connaissances, vos opinions et vos expériences. 
http://fr.answers.yahoo.com