Horton

Add missing commutators for distance operators

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 6254c55f815623bb74e2cf27562437dc3b2aa2c8
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2019-07-14T11:55:01Z
Releases: 13.0 
Add missing commutators for distance operators

Some of <-> operators between geometric types have their commutators missed.
This commit adds them.  The motivation is upcoming kNN support for some of those
operators.

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

Files

PathChange+/−
src/backend/utils/adt/geo_ops.c modified +126 −10
src/include/catalog/pg_operator.dat modified +34 −8
src/include/catalog/pg_proc.dat modified +25 −0
src/test/regress/expected/geometry.out modified +494 −492
src/test/regress/sql/geometry.sql modified +8 −7

Discussion