@@ -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)
@@ -152,7 +152,7 @@ SELECT '' as six, box(f1) AS box FROM CIRCLE_TBL;
152152 | (2.12132034355964,2.12132034355964),(-2.12132034355964,-2.12132034355964)
153153 | (71.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548)
154154 | (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738)
155- | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642 )
155+ | (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559643 )
156156 | (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)
157157 | (170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548)
158158(6 rows)
@@ -504,7 +504,7 @@ SELECT '' AS twentyfour, c1.f1 AS circle, p1.f1 AS point, (p1.f1 <-> c1.f1) AS d
504504 ORDER BY distance, circle, point using <<;
505505 twentyfour | circle | point | distance
506506------------+----------------+------------+-------------------
507- | <(100,0),100> | (5.1,34.5) | 0.976531926977965
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
510510 | <(100,0),100> | (-3,4) | 3.07764064044151
@@ -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) | 26.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