[postgis-tickets] r17264 - Add lost rounding for PG12

Darafei komzpa at gmail.com
Tue Feb 19 11:28:14 PST 2019


Author: komzpa
Date: 2019-02-19 23:28:14 -0800 (Tue, 19 Feb 2019)
New Revision: 17264

Modified:
   trunk/regress/core/measures.sql
Log:
Add lost rounding for PG12


Modified: trunk/regress/core/measures.sql
===================================================================
--- trunk/regress/core/measures.sql	2019-02-20 06:55:15 UTC (rev 17263)
+++ trunk/regress/core/measures.sql	2019-02-20 07:28:14 UTC (rev 17264)
@@ -107,11 +107,11 @@
 
 select 'distancepoly2',
 		ST_Distance(a, b),
-			st_maxdistance(a, b),
-				st_astext(st_shortestline(a,b)),
-					st_astext(st_shortestline(b,a)),
-						st_astext(st_longestline(a,b)),
-							st_astext(st_longestline(b,a)) from (
+		st_maxdistance(a, b)::numeric(12,6),
+		st_astext(st_shortestline(a,b)),
+		st_astext(st_shortestline(b,a)),
+		st_astext(st_longestline(a,b)),
+		st_astext(st_longestline(b,a)) from (
 	select ST_GeomFromText('POLYGON((17 14, 16 17, 17 18, 17 17, 17 14))') as a,
 			ST_GeomFromText('POLYGON((-1 -1, -1 25, 25 25, 25 -1, -1 -1), (14 14,14 19,19 19,19 14,14 14))') as b
 	) as foo;
@@ -118,11 +118,11 @@
 
 select 'distancepoly3',
 		ST_Distance(a, b),
-			st_maxdistance(a, b)::numeric(12,6),
-				st_astext(st_shortestline(a,b)),
-					st_astext(st_shortestline(b,a)),
-						st_astext(st_longestline(a,b)),
-							st_astext(st_longestline(b,a)) from (
+		st_maxdistance(a, b)::numeric(12,6),
+		st_astext(st_shortestline(a,b)),
+		st_astext(st_shortestline(b,a)),
+		st_astext(st_longestline(a,b)),
+		st_astext(st_longestline(b,a)) from (
 	select ST_GeomFromText('POLYGON((17 16, 16 17, 17 19, 17 17, 17 16))') as a,
 			ST_GeomFromText('POLYGON((-1 -1, -1 25, 25 25, 25 -1, -1 -1), (14 14,14 19,19 19,19 14,14 14))') as b
 	) as foo;



More information about the postgis-tickets mailing list