@@ -127,7 +127,7 @@ SELECT '' AS thirty, p.f1, l.s, p.f1 ## l.s AS closest
127127 | (-5,-12) | [(10,-10),(-3,-4)] | (-1.60487804878049,-4.64390243902439)
128128 | (10,10) | [(10,-10),(-3,-4)] | (2.39024390243902,-6.48780487804878)
129129 | (0,0) | [(-1000000,200),(300000,-40)] | (0.0028402365895872,15.384614860264)
130- | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140473 )
130+ | (-10,0) | [(-1000000,200),(300000,-40)] | (-9.99715942258202,15.3864610140472 )
131131 | (-3,4) | [(-1000000,200),(300000,-40)] | (-2.99789812267519,15.3851688427303)
132132 | (5.1,34.5) | [(-1000000,200),(300000,-40)] | (5.09647083221496,15.3836744976925)
133133 | (-5,-12) | [(-1000000,200),(300000,-40)] | (-4.99494420845634,15.3855375281616)
@@ -150,11 +150,11 @@ SELECT '' as six, box(f1) AS box FROM CIRCLE_TBL;
150150 six | box
151151-----+----------------------------------------------------------------------------
152152 | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964)
153- | (71.7106781186547 ,72.7106781186547 ),(-69.7106781186547 ,-68.7106781186547 )
154- | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737 )
155- | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642 )
153+ | (71.7106781186548 ,72.7106781186548 ),(-69.7106781186548 ,-68.7106781186548 )
154+ | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738 )
155+ | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643 )
156156 | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)
157- | (170.710678118655,70.7106781186547 ),(29.2893218813453 ,-70.7106781186547 )
157+ | (170.710678118655,70.7106781186548 ),(29.2893218813452 ,-70.7106781186548 )
158158(6 rows)
159159
160160-- translation
@@ -503,11 +503,11 @@ SELECT '' AS twentyfour, c1.f1 AS circle, p1.f1 AS point, (p1.f1 <-> c1.f1) AS d
503503 WHERE (p1.f1 <-> c1.f1) > 0
504504 ORDER BY distance, circle, point using <<;
505505 twentyfour | circle | point | distance
506- ------------+----------------+------------+------------------
507- | <(100,0),100> | (5.1,34.5) | 0.97653192697797
506+ ------------+----------------+------------+-------------------
507+ | <(100,0),100> | (5.1,34.5) | 0.976531926977964
508508 | <(1,2),3> | (-3,4) | 1.47213595499958
509509 | <(0,0),3> | (-3,4) | 2
510- | <(100,0),100> | (-3,4) |3.07764064044152
510+ | <(100,0),100> | (-3,4) | 3.07764064044151
511511 | <(100,0),100> | (-5,-12) | 5.68348972285122
512512 | <(1,3),5> | (-10,0) | 6.40175425099138
513513 | <(1,3),5> | (10,10) | 6.40175425099138
@@ -519,7 +519,7 @@ SELECT '' AS twentyfour, c1.f1 AS circle, p1.f1 AS point, (p1.f1 <-> c1.f1) AS d
519519 | <(0,0),3> | (10,10) | 11.142135623731
520520 | <(1,3),5> | (-5,-12) | 11.1554944214035
521521 | <(1,2),3> | (-5,-12) | 12.2315462117278
522- | <(1,3),5> | (5.1,34.5) | 26.7657047773223
522+ | <(1,3),5> | (5.1,34.5) |7657047773224
523523 | <(1,2),3> | (5.1,34.5) | 29.757594539282
524524 | <(0,0),3> | (5.1,34.5) | 31.8749193547455
525525 | <(100,200),10> | (5.1,34.5) | 180.778038568384