Table 9-7. PostgresIP V4 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 |
| %gt;= | Greater or equal | '192.168.1.5'::inet >= '192.168.1.5'::inet |
| %gt; | Greater | '192.168.1.5'::inet %gt; '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 |