Horton

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

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: c085e1c1cb4e29637552f5d250d45ad0cb83e5cf
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2019-07-14T12:09:15Z
Releases: 13.0 
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

Files

PathChange+/−
doc/src/sgml/gist.sgml modified +1 −0
src/backend/access/gist/gistproc.c modified +31 −17
src/include/catalog/pg_amop.dat modified +3 −0
src/include/catalog/pg_amproc.dat modified +2 −0
src/include/catalog/pg_proc.dat modified +4 −0
src/test/regress/expected/gist.out modified +76 −0
src/test/regress/sql/gist.sql modified +16 −0

Documentation touched

Discussion