↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Operators / Geometric

<^(point,point)

deprecated, use <<| instead

Reading PostgreSQL 18.6.

Description

deprecated, use <<| instead

Left operand
point
Right operand
point
Result type
bool
Implementing function
point_below(point,point)
Operator kind
Binary
Hash join candidate
no
Merge join candidate
no

Usage

<^(point,point) → bool

Catalog interpretation

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.

Declared operator-family membership

Index AMFamilyStrategyPurposeOrdering family
GiSTpoint_ops29search
SP-GiSTquad_point_ops29search
SP-GiSTkd_point_ops29search

Related entries

Documentation and source

Source build
Version
18.6
Build
https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
Source fingerprint
555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Compare versions

PostgreSQL 13 → 14: changed.

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -8,7 +8,7 @@
       "purpose": "search",
       "right_type": "point",
       "sort_family": "",
-      "strategy": "10"
+      "strategy": "29"
     },
     {
       "family": "kd_point_ops",
@@ -18,7 +18,7 @@
       "purpose": "search",
       "right_type": "point",
       "sort_family": "",
-      "strategy": "10"
+      "strategy": "29"
     },
     {
       "family": "quad_point_ops",
@@ -28,7 +28,7 @@
       "purpose": "search",
       "right_type": "point",
       "sort_family": "",
-      "strategy": "10"
+      "strategy": "29"
     }
   ],
   "operator": {

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

Export JSON · Back to Operators · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.