This page in other versions: Unsupported versions: 6.5

IP V4 CIDR Operators

Table 4-6. PostgresIP V4 CIDR Operators

Operator Description Usage
< Less than '192.168.1.5'::cidr < '192.168.1.6'::cidr
<= Less than or equal '192.168.1.5'::cidr <= '192.168.1.5'::cidr
= Equals '192.168.1.5'::cidr = '192.168.1.5'::cidr
>= Greater or equal '192.168.1.5'::cidr >= '192.168.1.5'::cidr
> Greater '192.168.1.5'::cidr > '192.168.1.4'::cidr
<> Not equal '192.168.1.5'::cidr <> '192.168.1.4'::cidr
<< is contained within '192.168.1.5'::cidr << '192.168.1/24'::cidr
<<= is contained within or equals '192.168.1/24'::cidr <<= '192.168.1/24'::cidr
>> contains '192.168.1/24'::cidr >> '192.168.1.5'::cidr
>>= contains or equals '192.168.1/24'::cidr >>= '192.168.1/24'::cidr
Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group