On Thu, Apr 22, 2021, 15:12 msdemlei ***@***.***> wrote: This PR, developed by Credativ in
https://github.com/credativ/pgsphere/, adds support for IVOA Multi-Order Coverage maps (
https://ivoa.net/documents/MOC/). They can be serialised and deserialised (to ASCII MOCs), they can be produced from polygons and circles, the can be intersected and joined. A simple indexing scheme is also provided. ------------------------------ You can view, comment on, or merge this pull request online at:
#1 Commit Summary - pgsphere_1.1.4.916 - comment fixes - healpix_bare support added. - Compatibility with PostgreSQL 11 for GAVO extensions - init_test.out diffs - No longer putting .git into the tarball - ignore past Chealpix oddities - Import healpix_bare 1.0 - Add .gitlab-ci.yml - Add alternate expected output file for PG12 - Ignore more build artifacts - Makefile: Default to USE_PGXS - Build healpix_bare directly from toplevel Makefile - Only override CXXFLAGS on PG10 and older - doc: Fix syntax of CREATE INDEX statement - Add .travis.yml - Bump version to 1.2.0 and implement smoc_union aka || - Call add_to_map directly without going through add_to_moc - Implement smoc_intersection aka * - sum() and intersection() aggregates - Implement = and <> on smoc - Add smoc_disc(order, theta, phi, radius) - Upgrade travis to bionic to get newer libhealpix-cxx-dev - Remove unused empty file - Use | and & for moc union and intersection - Variables cleanup - Check order in smoc_disc - create_moc_release_context always returns 1, change to void and remove error checking in callers - Implement smoc-from-scircle, and swap order of arguments in smoc_disc - Implement smoc overlap - Fix variable declaration warnings - Run tests with -Werror - Add missing function prototypes - Simplify linking with g++ - Makefile: Suppress declaration-after-statement in healpix_bare.c - Refresh sparse.c and sscan.c - Add IMMUTABLE and PARALLEL SAFE decorators to moc functions - Ignore tags file - Move conv_theta and math constants to new header pgs_util.h - Implement smoc(order, spoly)::smoc - Comment all functions and operators - Add smoc subset operators - Use query_*_inclusive and add more test cases - Fix format warning on 32 bit - Fix spoly detoasting in smoc_spoly() - Drop MOC_FORMAT_64X and obsolete code using it - Add smoc_info() function - Remove redundant variable - Speed up smoc_eq by detoasting header only first - Test equality on a large smoc - Speed up overlaps operation by looking at the smoc header first - Speed up subset operations by looking at the smoc header first - Add smoc rounding function that converts smocs to lower order - Test smoc_round on level 0 - GIN index support - GIN: check && 'empty' - Use space as moc interval separator as per recent standards - Implement subset/superset for GIN - Rename smoc_round to smoc_degrade - Refactor gin_extact functions - Add a second gin opclass smoc_gin_ops_fine using level 8 - Add smoc(order, spoint) function - Store original moc order - Include stored moc order in output - Catch PlanckError - doc/Makefile: Default to USE_PGXS and openjade, and build docs during tests - PG13 compatibility - doc: smoc type - smoc documentation - Support equality lookups - Implement inequality index lookups - Remove beta README.GAVO file - Expand docs with more smoc details - Rename smoc_area to area and make it return steradians - moc: Fix regression test deviation on i386 - Fix smoc_degrade bitmask on 32bit - Rename internal function moc_round to moc_degrade for consistency - Fix gin key extraction on 32bit - Accept varying moc100 regression output on 32bit - Add new expected output files for PG13 File Changes - *M* .gitignore <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-bc37d034bad564583790a46f19d807abfe519c5671395fd494d8cce506c42947> (8) - *A* .gitlab-ci.yml <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-037ea159eb0a7cb0ac23b851e66bee30fb838ee8d0d99fa331a1ba65283d37f7> (22) - *A* .travis.yml <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-6ac3f79fc25d95cd1e3d51da53a4b21b939437392578a35ae8cd6d5366ca5485> (30) - *M* Makefile <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-76ed074a9305c04054cdebb9e9aad2d818052b07091de1f20cad0bbac34ffb52> (172) - *M* doc/Makefile <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-f48ddfd1eec38c4d39f84e195259371f8397cd30146f46b113bdcb4590ed262c> (7) - *M* doc/constructors.sgm <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-29f408668066752c862d63626faa3baead1a54518fff5b3d083a402ccbb0e4a7> (46) - *M* doc/functions.sgm <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-0180546dcadb87a25b4e0163d2f31e9c231e7bf6bb5bfb68c469bdde943aea0c> (73) - *M* doc/img/Makefile <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-7fed41f968335b44d6dd01a6ad72dd030746ead066c76f9d6b600a91407256b1> (3) - *D* doc/img/logo.jpg <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-f220f06c1ec6b50bf94447698ce36646558fd3e5bdb842127ca27b02e97214db> (0) - *A* doc/img/logo.png <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-fc78cd769239ef24e5fc6ab741fc80e8547605279ec95803a8ae185a8292bfbd> (0) - *M* doc/img/logo.xcf <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-d4faec13081ffdda7fb0a5df0a1231862e8d007cbafbe9d8d1e75908c3e0f9d9> (0) - *A* doc/img/smoc.png <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-e1b8d916dbbd62af112dea14afd08dd0b26f68e9d96e77c8660867426a01c5fb> (0) - *M* doc/indices.sgm <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-2a449b2ee27b81ecb5623950fe73125a7fa917450e5cb392569e128c9e526655> (45) - *M* doc/operators.sgm <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-599b701bba2d7aeba66e2bb253e45ea505619cb84affd806e61c2f15f5359ce1> (47) - *M* doc/pg_sphere.dsl-dist <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-993b767f7daa1fefa73d22b57576e2674c961d96ecd2747fcedc58b4f4c37df0> (3) - *M* doc/pg_sphere.xml <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-f93019561c828917548ada576f5cb4334448deefc71bc2c1f2fa5a96b3a6990d> (7) - *M* doc/types.sgm <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-f65e160e10e0e9cd924f723d4d78681e35a363b1eb394852a75f3335d7017480> (69) - *M* expected/bounding_box_gist.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-55c855d45b692ffa9ab724208a013f64561c7111492294ddca787f78ff40390b> (151) - *A* expected/bounding_box_gist_1.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-fa4d8a691ed3a2bfb989a5739076fbb95f7a68c48b0aeeec4aee4b96c62ddc74> (240) - *A* expected/healpix.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-07e58ecbf5a0a9592722ace822fe14067526490271e25341ceda36a7f3d3d012> (16847) - *M* expected/index.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-244624d8e6ce6511db1720b066f2b1c1cc26e34574758e636b46c6eb933ff38f> (28) - *A* expected/index_9.5.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-541e8ef2a97fa53328d76d293f8c0ac3e363b7897d0238bb016fec9d3b72b441> (62) - *A* expected/init_test.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-69cc48c563eaece9766bf637a45e3090a42a6b75fcf7c495792d757d9fbf800f> (37) - *A* expected/moc.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-dcff666f94878f03fec9f7513173419531c83e988d9a9f21ed40405f3f5e5b30> (779) - *A* expected/moc1.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-8e579a384fbe45252a7fc6315617404c5dfb3ed6aca40bb35d6c00eeac988c0c> (120) - *A* expected/moc100.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-e6e1fab1fb137177d19d722f005e23c9945f03816a06091a27040eae40b65247> (252) - *A* expected/moc100_1.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-4c325cd450a79a567df8a81bfc5b47393807025595520fef89e0feb0d368fdbe> (252) - *A* expected/moc100_2.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-17bf4cace6341e865ddbeb1f7aeafea589d499f32a03cac1c0678a9631401cab> (286) - *A* expected/moc100_3.out <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-460ba1d5e4c8bd3919860f8e5e5995d0092a271dd94ecdcfeacbdf36469e477b> (286) - *M* gist.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-932a1fb7a6ab1f29131f5f950ad2ca62db0c33abd39cf83a0df4cb7279b8764a> (429) - *M* gist.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-22553ff2d171cf28564173fc47424cfb63bc91db166b1fa1c6fb52b9057b8048> (8) - *M* gnomo.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-3632544ed95e0ff9f10476d7b255af4947e4e9b27a37509400346ff65a8519d3> (5) - *A* gnomo.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-2973050036006f2d8c43fdbddd178a9b3994226a116420e39306fc0261df3849> (9) - *M* gnomo.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-d3f687a9e238d735210f3dfa743fcb44ae4d619889a2d56073be1e55fd1afb6c> (4) - *M* gq_cache.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-a456be67f2b47f37f1cc7cf39fee82494dc68b3b1652beed02c826479fb52782> (12) - *A* healpix.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-66e34909e7129b501f31870f0bfa90dca040aa4bef935b89b464067358e3813f> (233) - *A* healpix.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-382c0e2a08a48ff4c5486398988d7a2b013222e16f3707ae0c2a12679927b7e0> (99) - *A* healpix_bare/LICENSE <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-a08aeebb33617e40ccb3dffe729e03a843b5afc5a9492f8d2d4ab2de041e945f> (29) - *A* healpix_bare/NEWS <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-98ded5bc53f1944f8a008e48881def3bd60473f2181f95e3523dfd5d07dcc138> (2) - *A* healpix_bare/README <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-aabfc75e15de5a9a10267d6d60dc0a58986b9f30db99b0ceabb9482fa5b5b88b> (42) - *A* healpix_bare/healpix_bare.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-928b1feab70d3e950c92ed49301bf2e2281726ac8fcc72b00bf53bf6a21680d0> (310) - *A* healpix_bare/healpix_bare.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-1e1cd70acc8cccd919fc51201e2c0f828bd18b0b9cdcafaa6eeb794e55b074ca> (118) - *A* healpix_bare/test.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-c2a797f192a295b3da58a09f4bb859c9ebdff501431dad3fa60747d0a85387b7> (129) - *A* index_9.5 <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-5f7a2e5533df6bb8117cf33b42e2ee0751ea46d377cdba5373e9c371662dc5f8> (0) - *M* key.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-5c83bfa9863a8ec3e7bcd9a86671123047c884eef2a156f4b6824a66bb341f9b> (28) - *A* moc.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-350c5520cae4660aff3936f738f8cd116a15f37e5e8ff73a8ae80d0678d61fd8> (1204) - *M* path.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-dd5e9dc8fe1f52308750c5b22086433b63835d5a70fc1d0b910fba8b1aceb694> (4) - *M* path.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-ef57d519f1a2a1355f11a493b14895f20280b020c5f1a140994aa286219c77df> (6) - *A* pg_sphere--1.2.0.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-245617666e9634da59648218578e84d6b38f40e596bbd37bdb39cb66ecb8368a> (2) - *M* pg_sphere.control <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-9e7a22ef5c901657b32e6e7022b3e1f7a32aabc7f7c24193e87b5704958806b0> (2) - *M* pg_sphere.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-daecd1bd44d2cb0d6f78aca21ea4f7f323964e701fb5707c899fb34e75e207c0> (13) - *A* pgs_9.5.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-032dd0e72068d1aa8ea33ac336d4bc6ae00e3fc1905b2edb72828325931406ef> (7) - *A* pgs_chealpix.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-801b4bbd21b53fd71b94cf715a18d93cf3bc4b43f40838a732265b1cb31b7e4f> (16) - *M* pgs_contains_ops.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-01cce773ef9b51e3c164594888acd89e7a5201a9f7ebd3154e7f50441191ae09> (6) - *M* pgs_contains_ops_compat.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-668a9b51c203c97b391329c365f1d900893187ad9ea823153494fea24849fe5b> (6) - *M* pgs_gist.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-61dbd08710a3458793db82665eaa7ef79348b10170edead87af8b3a5a2261c83> (2) - *A* pgs_gist_pointkey.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-6b7362176cb2382d3cbb721a8a0b728dddf28d7e8af19132f3a44984293e8eda> (38) - *A* pgs_gist_spoint3.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-8b8e4c488653f9be13166d3a7b2fd88775432c44e470bb6ea5362b718194e060> (69) - *A* pgs_healpix.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-014752725b6a9b4f034894c64922658baed265cb1893e17cbcffce41df4bf6f2> (34) - *A* pgs_moc.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-2ad8bcf9ba5e4c6699b8a89f95ab29bc6d778c46277c84aa6aa0a2bf64bb7f29> (133) - *A* pgs_moc_compat.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-155743fe3670cc46d12c89d08cfc1de3cfabeaa84c83c504bceeedc8371467d7> (22) - *A* pgs_moc_ops.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-c6ad7d4c904835e5a3b024f22c417952ef58751e43fdba286cc407ae5135bf65> (372) - *A* pgs_moc_type.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-a38d8907bb4b1c299e394b91d015931aa799b83a16193c3cf08d860a238fff35> (169) - *A* pgs_process_moc.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-584164001e6d634de32c9507d04b8dae579f9dbd46966b2f2041e1bda5f52931> (172) - *A* pgs_util.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-e711032045c806a057665170850d7e5dea6cc69df710e6a2056c0a94bb6cf2f4> (29) - *M* polygon.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-953f22d2ad4b27c4f34ec5b46ef8b6c39d25326c7ce951858692fc03bbd98dde> (2) - *M* polygon.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-d16cfe773a607f041fdada277fd22b184d6660ee4632c381e789d28339de2389> (6) - *A* process_moc.cpp <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-d927e91feaa6409d554e93926c6a9c4556b1ef403aa55d3b4021398ac2323acf> (1050) - *M* sparse.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-7fc8acec3ffc4781b4d5874c70a457d8be5c82925042dcbfe992926f4d33958d> (392) - *M* sparse.h <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-4b220cb76a00154ef68645bf54bc269b72d4bee08e1f02b0b6c30f16b39bb37a> (15) - *M* sql/bounding_box_gist.sql <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-b88659ae343f6c5f02132c8ed42e35b76da41566117c03a80e6f8ae0ce880779> (23) - *A* sql/healpix.sql <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-eba6c6c47a48a84d4b5b075ac86dbe2fa46a976fb11a9b50a357cff245e51035> (2866) - *M* sql/index.sql <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-cafcdf2fbc095f14d50c0f1dfa06f99e6631ec392ef9d4219d6d87b6d96e24d3> (10) - *A* sql/index_9.5.sql <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-464075507742281db71e2ea98c00acd1d3335e08264f3cc8638112cd754cf836> (18) - *A* sql/init_test.sql <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-30ce40254cc1b230b307eadbe383196a01652470b3dbb8990c068dfb2709d5cf> (4) - *A* sql/moc.sql <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-aa38d50d96ccf65ea78fa892b32e697ffd2c76f952137577427bc5b78313c07c> (177) - *A* sql/moc1.sql <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-e59f9d0cf0f6fe3d8123a556f30c74fa5f4996489dbd9c1eff41f6accb0188f3> (40) - *A* sql/moc100.sql <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-0bdda40df11a0299794a2115585f631464089c3c571817f94146075347b4c3a7> (166) - *M* sscan.c <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-58bfcf8e8ce047e76dc5048fe2ac354d9aaaf907ef38d783fd64301f9a49fecc> (2140) - *A* test_top_build_dir/Makefile <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-7239c7cd65b2dc331adce11dac56a29a29cede61a04b7cc16437cff5d5aba082> (2) - *A* upgrade_scripts/contains-ops-fixes-1.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-0b1f71a583b00285e02802b49096bb1bd9a815f47afc8ddb853f5f60746a092a> (39) - *A* upgrade_scripts/contains-ops-fixes-2.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-99351ecaecb2e18abd1f0f6783392420877c78e253d513f9d50881851aafa7bd> (26) - *A* upgrade_scripts/pg_sphere--1.0--1.0_gavo.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-6a049c99d3c041738f4bcf6a6a29ae6d5f9c427d6d0637d80ef93c3450ccb1b3> (2) - *A* upgrade_scripts/pg_sphere--1.0--1.1.5_from_2015-08-31.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-ca2e742a8200dc7a5fe2110f63c4cd6909003701f566b15f7bcbad1b50d2cdf7> (2) - *A* upgrade_scripts/pg_sphere--1.0--1.1.5_from_2016-02-07.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-9cc327e02cd045aff87dc31e0f22a687b81e9b9e940e5be0ea952b69f0e93101> (2) - *A* upgrade_scripts/pg_sphere--1.0_gavo--1.1.5beta0gavo.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-b3f42f60d8f35fb472d78da5f002ccebd0ecac044239b03a24c01bb9926a9dad> (2) - *A* upgrade_scripts/pg_sphere--1.1.5--1.1.5.1.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-31fa50a52712ef455a70f017e2880e4ea0c6c26e51859a5d8e57d31518f97804> (2) - *A* upgrade_scripts/pg_sphere--1.1.5_from_2015-08-31--1.1.5.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-72cbe86ca12eee376c20ffe72b7a2bd5ad64ec408d2d40d9341cc9f3bf5b3b7a> (2) - *A* upgrade_scripts/pg_sphere--1.1.5_from_2016-02-07--1.1.5.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-984c3e7fb56c57ee8e2cc805395c42b6fc9c4603b42427a1412064837b19f6cd> (2) - *A* upgrade_scripts/pg_sphere--1.1.5beta0gavo--1.1.5beta2gavo.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-2317dcaff2c2090bcf1956fbb26744c662fe22abf52ca143e2d12bfccdc6c5a5> (2) - *A* upgrade_scripts/pg_sphere--1.1.5beta2gavo--1.1.5beta4gavo.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-9aedc02770a9c04f54b57ab201977d9a6889fdfa993b3d4313d01377055adee4> (2) - *A* upgrade_scripts/pg_sphere--unpackaged--1.1.5.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-2d0b359fe16aaf178a9204aaf911595aea40fc759830b13f5f8e5a39cdde42ff> (2) - *A* upgrade_scripts/pg_sphere--unpackaged--1.1.5beta0gavo.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-4ea24dd5434152d1cd0bd216d697a50917d80993597d0b1118b1993337df70bb> (2) - *A* upgrade_scripts/pgs_box.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-006d2586c625ee8528190a6bc1c173777c4d4524cd054bd4ba201ac83e6fd317> (95) - *A* upgrade_scripts/pgs_circle.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-6c0eb4d5da68a16d9efafebd6f6ae75e8473fea54fa887a56cc6a1f5ecbc6346> (31) - *A* upgrade_scripts/pgs_contains_ops_compat.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-c95d34b371050dbdd8e46945bf5444e995697f990a47080232540906c93d4e75> (120) - *A* upgrade_scripts/pgs_ellipse.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-9ad8fa05a05a8a8ed99b589e5985c119c598a12a023b7fc64191f56aa51cd071> (55) - *A* upgrade_scripts/pgs_euler.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-4e2397c006783c34d395e153f727463cefbaf9f755b7025fb086680928db79dc> (23) - *A* upgrade_scripts/pgs_gist.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-d1291b95e497384451b098aa4ddcff7650af4e7652d23d9d78b664c5b3d960f6> (27) - *A* upgrade_scripts/pgs_gist_contains_ops.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-0650efea6236c2ab122252a8898b57552c3e3c1452c622f14efda482a0b590ef> (73) - *A* upgrade_scripts/pgs_gist_drop_spoint2.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-8b47abc8db3e2b06917bea4452f465e58fa62c47b399d031592efc7373941117> (11) - *A* upgrade_scripts/pgs_line.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-f34dd0c614d07d1e641fa4fc97ba7e605e49c6d3a168bf80aa4f54a723b4539b> (41) - *A* upgrade_scripts/pgs_path.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-53f80fa22aba27c5b3b42e06b717c972d1b1d99bdb0ba6de429095c005316b26> (67) - *A* upgrade_scripts/pgs_point.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-0b0bdeedb710d72ae2f6efeeec26f8bfbaff4996f00e475c6ef9e22b3d8a8466> (14) - *A* upgrade_scripts/pgs_polygon.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-c3c27e02f30614e636a4bd46b9e2cf7e99fb34444629573101342ef2ec240378> (68) - *A* upgrade_scripts/pgs_pre111.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-c56c46c590a4fe147b6d1b7c527072c4d6fcd60d3eda56cf86f58f69b682352f> (7) - *A* upgrade_scripts/pgs_types.sql.in <
https://github.com/postgrespro/pgsphere/pull/1/files#diff-042c47d7fee6d5f7f99007f513afb4147db539a263ca1cab0376781386d893e3> (24) Patch Links: -
https://github.com/postgrespro/pgsphere/pull/1.patch -
https://github.com/postgrespro/pgsphere/pull/1.diff — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <
#1>, or unsubscribe <
https://github.com/notifications/unsubscribe-auth/ABQURYTZVLLA5K7EMAKTDILTKAHCRANCNFSM43MKRFYQ> .
This PR, developed by Credativ inhttps://github.com/credativ/pgsphere/, adds support for IVOA Multi-Order Coverage maps (https://ivoa.net/documents/MOC/). They can be serialised and deserialised (to ASCII MOCs), they can be produced from polygons and circles, the can be intersected and joined. A simple indexing scheme is also provided.