Migrate rtree_gist functionality into the core system, and add some
Tom Lane <tgl@sss.pgh.pa.us>
Migrate rtree_gist functionality into the core system, and add some basic regression tests for GiST to the standard regression tests. I took the opportunity to add an rtree-equivalent gist opclass for circles; the contrib version only covered boxes and polygons, but indexing circles is very handy for distance searches.
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/access/gist/gistproc.c | added | +708 −0 |
| src/backend/access/gist/Makefile | modified | +3 −2 |
| src/backend/utils/adt/geo_ops.c | modified | +34 −7 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/include/catalog/pg_amop.h | modified | +52 −1 |
| src/include/catalog/pg_amproc.h | modified | +25 −1 |
| src/include/catalog/pg_opclass.h | modified | +4 −1 |
| src/include/catalog/pg_operator.h | modified | +5 −3 |
| src/include/catalog/pg_proc.h | modified | +29 −1 |
| src/include/utils/geo_decls.h | modified | +17 −2 |
| src/test/regress/data/rect.data | modified | +278 −0 |
| src/test/regress/expected/create_index.out | modified | +141 −1 |
| src/test/regress/expected/opr_sanity.out | modified | +16 −1 |
| src/test/regress/expected/sanity_check.out | modified | +3 −1 |
| src/test/regress/sql/create_index.sql | modified | +86 −1 |
| src/test/regress/sql/opr_sanity.sql | modified | +3 −0 |