Unsupported versions: 7.0
Historical version. PostgreSQL 7.0 has reached end of support. See the current manual.
IP V4 INET Operators
Table 4-7. PostgresIP V4 INET Operators
| Operator | Description | Usage |
|---|---|---|
| < | Less than | '192.168.1.5'::inet < '192.168.1.6'::inet |
| <= | Less than or equal | '192.168.1.5'::inet <= '192.168.1.5'::inet |
| = | Equals | '192.168.1.5'::inet = '192.168.1.5'::inet |
| >= | Greater or equal | '192.168.1.5'::inet >= '192.168.1.5'::inet |
| > | Greater | '192.168.1.5'::inet > '192.168.1.4'::inet |
| <> | Not equal | '192.168.1.5'::inet <> '192.168.1.4'::inet |
| << | is contained within | '192.168.1.5'::inet << '192.168.1/24'::inet |
| <<= | is contained within or equals | '192.168.1/24'::inet <<= '192.168.1/24'::inet |
| >> | contains | '192.168.1/24'::inet >> '192.168.1.5'::inet |
| >>= | contains or equals | '192.168.1/24'::inet >>= '192.168.1/24'::inet |
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.