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

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

Index-based calculation of this operator is exact.  So, signature of
gist_bbox_distance() function is changes so that caller is responsible for
setting *recheck flag.

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/c085e1c1cb4e29637552f5d250d45ad0cb83e5cf

Modified Files
--------------
doc/src/sgml/gist.sgml             |  1 +
src/backend/access/gist/gistproc.c | 48 +++++++++++++++---------
src/include/catalog/pg_amop.dat    |  3 ++
src/include/catalog/pg_amproc.dat  |  2 +
src/include/catalog/pg_proc.dat    |  4 ++
src/test/regress/expected/gist.out | 76 ++++++++++++++++++++++++++++++++++++++
src/test/regress/sql/gist.sql      | 16 ++++++++
7 files changed, 133 insertions(+), 17 deletions(-)