Thread: pgsql: Add support for <-> (box, point) operator to SP-GiST box_ops

pgsql: Add support for <-> (box, point) operator to SP-GiST box_ops

From
Alexander Korotkov
Date:
Add support for <-> (box, point) operator to SP-GiST box_ops

Opclass support functions already can handle this operator, just catalog
adjustment appears to be required.

Discussion: https://postgr.es/m/f71ba19d-d989-63b6-f04a-abf02ad9345d%40postgrespro.ru
Author: Nikita Glukhov
Reviewed-by: Tom Lane, Alexander Korotkov

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/075f0a880fbf790f4a3dcac83e2d5125bcad9646

Modified Files
--------------
doc/src/sgml/spgist.sgml                   |  1 +
src/include/catalog/pg_amop.dat            |  4 ++
src/test/regress/expected/box.out          | 82 +++++++++++++++++++++++++-----
src/test/regress/expected/sanity_check.out |  2 +
src/test/regress/sql/box.sql               | 70 ++++++++++++++++++++-----
5 files changed, 135 insertions(+), 24 deletions(-)