select * from net where '213.186.192.231'::inet<<net;
select * from net where network_sub('213.186.192.231',net);
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
Киевская городская библиотека
собрана Максимом Мошковым
