Horton

Rename the "point is strictly above/below point" comparison operators.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: 0cc99327888840f2bf572303b68438e4caf62de9
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2020-11-23T16:38:37Z
Releases: 14.0 
Rename the "point is strictly above/below point" comparison operators.

Historically these were called >^ and <^, but that is inconsistent
with the similar box, polygon, and circle operators, which are named
|>> and <<| respectively.  Worse, the >^ and <^ names are used for
*not* strict above/below tests for the box type.

Hence, invent new operators following the more common naming.  The
old operators remain available for now, and are still accepted by
the relevant index opclasses too.  But there's a deprecation notice,
so maybe we can get rid of them someday.

Emre Hasegeli, reviewed by Pavel Borisov

Discussion: https://postgr.es/m/24348.1587444160@sss.pgh.pa.us

Files

PathChange+/−
doc/src/sgml/func.sgml modified +14 −32
doc/src/sgml/gist.sgml modified +2 −2
doc/src/sgml/spgist.sgml modified +7 −7
src/backend/access/gist/gistproc.c modified +11 −1
src/backend/access/spgist/spgkdtreeproc.c modified +2 −0
src/backend/access/spgist/spgquadtreeproc.c modified +4 −0
src/include/access/stratnum.h modified +3 −1
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_amop.dat modified +24 −6
src/include/catalog/pg_operator.dat modified +11 −2
src/test/regress/expected/create_index.out modified +8 −8
src/test/regress/expected/create_index_spgist.out modified +38 −38
src/test/regress/expected/opr_sanity.out modified +4 −4
src/test/regress/expected/point.out modified +3 −3
src/test/regress/sql/create_index_spgist.sql modified +18 −18
src/test/regress/sql/create_index.sql modified +6 −6
src/test/regress/sql/point.sql modified +3 −3

Documentation touched

Discussion