|
Name |
|
Date |
Size |
#Lines |
LOC |
| .. | | 03-May-2022 | - |
| data/ | H | 30-Oct-2019 | - | 1,653 | 1,647 |
| doc/ | H | 30-Oct-2019 | - | 3,348 | 3,117 |
| expected/ | H | 30-Oct-2019 | - | 12,783 | 10,707 |
| sql/ | H | 30-Oct-2019 | - | 2,808 | 1,737 |
| testsuite/ | H | 30-Oct-2019 | - | 4,691 | 3,398 |
| .gitignore | H A D | 30-Oct-2019 | 56 | 6 | 6 |
| COPYRIGHT.pg_sphere | H A D | 30-Oct-2019 | 1.5 KiB | 28 | 23 |
| Makefile | H A D | 30-Oct-2019 | 1.9 KiB | 68 | 51 |
| README.pg_sphere | H A D | 30-Oct-2019 | 803 | 32 | 19 |
| box.c | H A D | 30-Oct-2019 | 33.5 KiB | 1,551 | 1,257 |
| box.h | H A D | 30-Oct-2019 | 9.4 KiB | 429 | 105 |
| circle.c | H A D | 30-Oct-2019 | 8.5 KiB | 413 | 351 |
| circle.h | H A D | 30-Oct-2019 | 3.3 KiB | 156 | 36 |
| ellipse.c | H A D | 30-Oct-2019 | 29 KiB | 1,433 | 1,182 |
| ellipse.h | H A D | 30-Oct-2019 | 7.2 KiB | 305 | 73 |
| euler.c | H A D | 30-Oct-2019 | 9.5 KiB | 530 | 449 |
| euler.h | H A D | 30-Oct-2019 | 3.8 KiB | 162 | 38 |
| gist.c | H A D | 30-Oct-2019 | 45.1 KiB | 2,005 | 1,585 |
| gist.h | H A D | 30-Oct-2019 | 3.6 KiB | 153 | 38 |
| gnomo.c | H A D | 30-Oct-2019 | 1.7 KiB | 70 | 46 |
| gnomo.sql.in | H A D | 30-Oct-2019 | 513 | 18 | 13 |
| gq_cache.c | H A D | 30-Oct-2019 | 3 KiB | 156 | 125 |
| key.c | H A D | 30-Oct-2019 | 8.6 KiB | 518 | 458 |
| key.h | H A D | 30-Oct-2019 | 4.2 KiB | 173 | 57 |
| line.c | H A D | 03-May-2022 | 19.9 KiB | 1,054 | 870 |
| line.h | H A D | 03-May-2022 | 7.2 KiB | 294 | 66 |
| output.c | H A D | 30-Oct-2019 | 10.6 KiB | 534 | 410 |
| path.c | H A D | 03-May-2022 | 20.6 KiB | 1,042 | 794 |
| path.h | H A D | 30-Oct-2019 | 6.5 KiB | 301 | 70 |
| pg_sphere.control | H A D | 30-Oct-2019 | 184 | 6 | 5 |
| pg_sphere.h | H A D | 30-Oct-2019 | 1.8 KiB | 63 | 29 |
| pgs_box.sql.in | H A D | 30-Oct-2019 | 28.3 KiB | 1,304 | 967 |
| pgs_circle.sql.in | H A D | 30-Oct-2019 | 9.4 KiB | 436 | 325 |
| pgs_contains_ops.sql.in | H A D | 30-Oct-2019 | 38.8 KiB | 1,471 | 1,212 |
| pgs_contains_ops_compat.sql.in | H A D | 30-Oct-2019 | 38.5 KiB | 1,475 | 1,215 |
| pgs_ellipse.sql.in | H A D | 30-Oct-2019 | 18.3 KiB | 799 | 586 |
| pgs_euler.sql.in | H A D | 30-Oct-2019 | 5.3 KiB | 223 | 169 |
| pgs_gist.sql.in | H A D | 30-Oct-2019 | 13.6 KiB | 428 | 367 |
| pgs_line.sql.in | H A D | 30-Oct-2019 | 12.5 KiB | 596 | 440 |
| pgs_path.sql.in | H A D | 30-Oct-2019 | 20.6 KiB | 930 | 697 |
| pgs_point.sql.in | H A D | 30-Oct-2019 | 3.5 KiB | 170 | 131 |
| pgs_polygon.sql.in | H A D | 30-Oct-2019 | 21.7 KiB | 946 | 706 |
| pgs_types.sql.in | H A D | 30-Oct-2019 | 3.2 KiB | 194 | 130 |
| point.c | H A D | 30-Oct-2019 | 4.8 KiB | 266 | 227 |
| point.h | H A D | 30-Oct-2019 | 1.8 KiB | 94 | 25 |
| polygon.c | H A D | 03-May-2022 | 29 KiB | 1,444 | 1,112 |
| polygon.h | H A D | 30-Oct-2019 | 8 KiB | 346 | 82 |
| sbuffer.c | H A D | 30-Oct-2019 | 5.7 KiB | 387 | 313 |
| sbuffer.h | H A D | 30-Oct-2019 | 5.1 KiB | 149 | 39 |
| sparse.c | H A D | 30-Oct-2019 | 55.2 KiB | 1,830 | 1,263 |
| sparse.h | H A D | 30-Oct-2019 | 2.7 KiB | 107 | 60 |
| sparse.y | H A D | 30-Oct-2019 | 4.1 KiB | 184 | 145 |
| sscan.c | H A D | 30-Oct-2019 | 44.4 KiB | 1,912 | 1,208 |
| sscan.l | H A D | 30-Oct-2019 | 1.1 KiB | 56 | 49 |
| types.h | H A D | 30-Oct-2019 | 577 | 21 | 11 |
| vector3d.c | H A D | 30-Oct-2019 | 645 | 37 | 29 |
| vector3d.h | H A D | 30-Oct-2019 | 800 | 41 | 14 |
README.pg_sphere
1This is an R-Tree implementation using GiST for spherical objects
2like spherical points and spherical circles with
3useful functions and operators.
4
5
6NOTICE:
7 This version will work only with postgresql version 9.1 and above.
8
9INSTALLATION:
10
11 -- build and install
12 gmake USE_PGXS=1 PG_CONFIG=/usr/bin/pg_config
13 gmake USE_PGXS=1 PG_CONFIG=/usr/bin/pg_config install
14 -- load extension
15 psql -c "CREATE EXTENSION pg_sphere;" <database>
16
17REGRESSION TEST (as the same user as the currently running postgresql server):
18
19 make USE_PGXS=1 installcheck
20
21LONG REGRESSION TEST:
22
23 make USE_PGXS=1 crushtest
24
25The 'make' program must be compatible with GNU make.
26
27For more information, have a look at http://pgsphere.projects.postgresql.org
28and https://github.com/akorotkov/pgsphere
29
30Have a lot of fun!
31
32