Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit90c4bab

Browse files
author
Thomas G. Lockhart
committed
Support full POSIX-style time zone: EST+3, PST-3, etc.
We probably support a superset of the spec, but I don't have the spec to confirm this.Update regression tests to include tests for this format.Update geometry.out with results from Linux RH 5.2 system(for last decimal place).
1 parentff0a420 commit90c4bab

File tree

3 files changed

+1477
-1121
lines changed

3 files changed

+1477
-1121
lines changed

‎src/test/regress/expected/geometry.out

Lines changed: 29 additions & 29 deletions
Original file line numberDiff line numberDiff line change
@@ -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.7106781186548,72.7106781186548),(-69.7106781186548,-68.7106781186548)
154-
| (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932738)
153+
| (71.7106781186547,72.7106781186547),(-69.7106781186547,-68.7106781186547)
154+
| (4.53553390593274,6.53553390593274),(-2.53553390593274,-0.535533905932737)
155155
| (3.12132034355964,4.12132034355964),(-1.12132034355964,-0.121320343559642)
156156
| (107.071067811865,207.071067811865),(92.9289321881345,192.928932188135)
157-
| (170.710678118655,70.7106781186548),(29.2893218813452,-70.7106781186548)
157+
| (170.710678118655,70.7106781186547),(29.2893218813453,-70.7106781186547)
158158
(6 rows)
159159

160160
-- translation
@@ -502,31 +502,31 @@ SELECT '' AS twentyfour, c1.f1 AS circle, p1.f1 AS point, (p1.f1 <-> c1.f1) AS d
502502
FROM CIRCLE_TBL c1, POINT_TBL p1
503503
WHERE (p1.f1 <-> c1.f1) > 0
504504
ORDER BY distance, circle, point using <<;
505-
twentyfour | circle | point | distance
506-
------------+----------------+------------+-------------------
507-
| <(100,0),100> | (5.1,34.5) | 0.976531926977965
508-
| <(1,2),3> | (-3,4) |1.47213595499958
509-
| <(0,0),3> | (-3,4) |2
510-
| <(100,0),100> | (-3,4) | 3.07764064044151
511-
| <(100,0),100> | (-5,-12) |5.68348972285122
512-
| <(1,3),5> | (-10,0) |6.40175425099138
513-
| <(1,3),5> | (10,10) |6.40175425099138
514-
| <(0,0),3> | (-10,0) |7
515-
| <(1,2),3> | (-10,0) |8.18033988749895
516-
| <(1,2),3> | (10,10) |9.0415945787923
517-
| <(0,0),3> | (-5,-12) |10
518-
| <(100,0),100> | (-10,0) |10
519-
| <(0,0),3> | (10,10) |11.142135623731
520-
| <(1,3),5> | (-5,-12) |11.1554944214035
521-
| <(1,2),3> | (-5,-12) |12.2315462117278
522-
| <(1,3),5> | (5.1,34.5) |26.7657047773223
523-
| <(1,2),3> | (5.1,34.5) |29.757594539282
524-
| <(0,0),3> | (5.1,34.5) |31.8749193547455
525-
| <(100,200),10> | (5.1,34.5) |180.778038568384
526-
| <(100,200),10> | (10,10) |200.237960416286
527-
| <(100,200),10> | (-3,4) |211.415898254845
528-
| <(100,200),10> | (0,0) |213.606797749979
529-
| <(100,200),10> | (-10,0) |218.254244210267
530-
| <(100,200),10> | (-5,-12) |226.577682802077
505+
twentyfour | circle | point | distance
506+
------------+----------------+------------+------------------
507+
| <(100,0),100> | (5.1,34.5) | 0.97653192697797
508+
| <(1,2),3> | (-3,4) | 1.47213595499958
509+
| <(0,0),3> | (-3,4) | 2
510+
| <(100,0),100> | (-3,4) |3.07764064044152
511+
| <(100,0),100> | (-5,-12) | 5.68348972285122
512+
| <(1,3),5> | (-10,0) | 6.40175425099138
513+
| <(1,3),5> | (10,10) | 6.40175425099138
514+
| <(0,0),3> | (-10,0) | 7
515+
| <(1,2),3> | (-10,0) | 8.18033988749895
516+
| <(1,2),3> | (10,10) | 9.0415945787923
517+
| <(0,0),3> | (-5,-12) | 10
518+
| <(100,0),100> | (-10,0) | 10
519+
| <(0,0),3> | (10,10) | 11.142135623731
520+
| <(1,3),5> | (-5,-12) | 11.1554944214035
521+
| <(1,2),3> | (-5,-12) | 12.2315462117278
522+
| <(1,3),5> | (5.1,34.5) | 26.7657047773223
523+
| <(1,2),3> | (5.1,34.5) | 29.757594539282
524+
| <(0,0),3> | (5.1,34.5) | 31.8749193547455
525+
| <(100,200),10> | (5.1,34.5) | 180.778038568384
526+
| <(100,200),10> | (10,10) | 200.237960416286
527+
| <(100,200),10> | (-3,4) | 211.415898254845
528+
| <(100,200),10> | (0,0) | 213.606797749979
529+
| <(100,200),10> | (-10,0) | 218.254244210267
530+
| <(100,200),10> | (-5,-12) | 226.577682802077
531531
(24 rows)
532532

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp