Wiki / Operators / Pseudo-types
-(anyrange,anyrange)
range difference
Reading PostgreSQL 18.6.
Description
range difference
- Left operand
- anyrange
- Right operand
- anyrange
- Result type
- anyrange
- Implementing function
- range_minus(anyrange,anyrange)
- Operator kind
- Binary
- Hash join candidate
- no
- Merge join candidate
- no
Usage
-(anyrange,anyrange) → anyrangeEnglish manual definition
Computes the difference of the ranges. The second range must not be contained in the first in such a way that the difference would not be a single range.
int8range(5,15) - int8range(10,20) → [5,10)
Catalog interpretation
The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.
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
- PostgreSQL 18 English manual: functions-range.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 17 → 18: unchanged.
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
&&(anyarray,anyarray)&&(anymultirange,anymultirange)&&(anymultirange,anyrange)&&(anyrange,anymultirange)&&(anyrange,anyrange)&<(anymultirange,anymultirange)&<(anymultirange,anyrange)&<(anyrange,anymultirange)&<(anyrange,anyrange)&>(anymultirange,anymultirange)&>(anymultirange,anyrange)&>(anyrange,anymultirange)
Export JSON · Back to Operators · Recorded in PostgreSQL 10 through 20; the first sample is not necessarily its introduction.