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 |