This page in other versions: Unsupported versions: 6.5

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
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group