diff -U3 /tmp/autopkgtest.AeHLJh/build.0sF/src/debian/tests/expected/064_tpoint_distance.test.out /tmp/regress.5KfpGS/results/064_tpoint_distance.test.out --- /tmp/autopkgtest.AeHLJh/build.0sF/src/debian/tests/expected/064_tpoint_distance.test.out 2023-05-29 20:41:45.000000000 +0000 +++ /tmp/regress.5KfpGS/results/064_tpoint_distance.test.out 2023-06-17 20:29:13.027801794 +0000 @@ -718,15 +718,15 @@ (1 row) SELECT round(tgeogpoint '[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03]' <-> tgeogpoint '[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03]', 6); - round ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - [156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST] + round +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + [156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST] (1 row) SELECT round(tgeogpoint '{[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}' <-> tgeogpoint '[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03]', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint 'Point(1.5 1.5)@2000-01-01' <-> tgeogpoint '{[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}', 6); @@ -742,15 +742,15 @@ (1 row) SELECT round(tgeogpoint '[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03]' <-> tgeogpoint '{[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint '{[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}' <-> tgeogpoint '{[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03],[Point(3.5 3.5)@2000-01-04, Point(3.5 3.5)@2000-01-05]}', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST], [0@Tue Jan 04 00:00:00 2000 PST, 0@Wed Jan 05 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST], [0@Tue Jan 04 00:00:00 2000 PST, 0@Wed Jan 05 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint 'Point(1.5 1.5 1.5)@2000-01-01' <-> tgeogpoint 'Point(2.5 2.5 2.5)@2000-01-01', 6); @@ -814,15 +814,15 @@ (1 row) SELECT round(tgeogpoint '[Point(1.5 1.5 1.5)@2000-01-01, Point(2.5 2.5 2.5)@2000-01-02, Point(1.5 1.5 1.5)@2000-01-03]' <-> tgeogpoint '[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03]', 6); - round ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - [156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST] + round +-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + [156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST] (1 row) SELECT round(tgeogpoint '{[Point(1.5 1.5 1.5)@2000-01-01, Point(2.5 2.5 2.5)@2000-01-02, Point(1.5 1.5 1.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}' <-> tgeogpoint '[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03]', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint 'Point(1.5 1.5 1.5)@2000-01-01' <-> tgeogpoint '{[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}', 6); @@ -838,15 +838,15 @@ (1 row) SELECT round(tgeogpoint '[Point(1.5 1.5 1.5)@2000-01-01, Point(2.5 2.5 2.5)@2000-01-02, Point(1.5 1.5 1.5)@2000-01-03]' <-> tgeogpoint '{[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST]} (1 row) SELECT round(tgeogpoint '{[Point(1.5 1.5 1.5)@2000-01-01, Point(2.5 2.5 2.5)@2000-01-02, Point(1.5 1.5 1.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}' <-> tgeogpoint '{[Point(2.5 2.5 2.5)@2000-01-01, Point(1.5 1.5 1.5)@2000-01-02, Point(2.5 2.5 2.5)@2000-01-03],[Point(3.5 3.5 3.5)@2000-01-04, Point(3.5 3.5 3.5)@2000-01-05]}', 6); - round --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- - {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 12:00:00 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 12:00:00 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST], [0@Tue Jan 04 00:00:00 2000 PST, 0@Wed Jan 05 00:00:00 2000 PST]} + round +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- + {[156855.662657@Sat Jan 01 00:00:00 2000 PST, 0@Sat Jan 01 11:59:59.999999 2000 PST, 156855.662657@Sun Jan 02 00:00:00 2000 PST, 0@Sun Jan 02 11:59:59.999999 2000 PST, 156855.662657@Mon Jan 03 00:00:00 2000 PST], [0@Tue Jan 04 00:00:00 2000 PST, 0@Wed Jan 05 00:00:00 2000 PST]} (1 row) ------------------------------------------------------------------------------- @@ -1361,15 +1361,15 @@ (1 row) SELECT asText(round(NearestApproachInstant(tgeogpoint '[Point(1.5 1.5)@2000-01-01, Point(2.5 2.5)@2000-01-02, Point(1.5 1.5)@2000-01-03]', tgeogpoint '[Point(2.5 2.5)@2000-01-01, Point(1.5 1.5)@2000-01-02, Point(2.5 2.5)@2000-01-03]'),6)); - astext -------------------------------------------------------- - POINT(1.999848 2.000076)@Sat Jan 01 12:00:00 2000 PST + astext +--------------------------------------------------------------