IP V4 INET Operators

Table 4-7. PostgresIP V4 INET Operators

OperatorDescriptionUsage
< 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