<^(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) → boolCatalog interpretation
The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.
Declared operator-family membership
| Index AM | Family | Strategy | Purpose | Ordering family |
|---|---|---|---|---|
| GiST | point_ops | 29 | search | |
| SP-GiST | quad_point_ops | 29 | search | |
| SP-GiST | kd_point_ops | 29 | search |
Related entries
Documentation and source
- Matching PostgreSQL source archive
- PostgreSQL 18 English manual: catalog-pg-operator.html
- PostgreSQL 18 English manual: catalog-pg-amop.html
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.