On 2010-11-20, Alexander Farber <alexander(dot)farber(at)gmail(dot)com> wrote:
>
> 1) if I'd like to compare just the first 3 numbers of
> the IP address instead of the 4, how can I do it?
> (yes, I know about the A,B,C type of IPv4 networks...)
have you heard of CIDR (what about IPV6, which I'm going to ignore,
but you should consider unless this code is throw-away)
just use set_masklen and the >> operator.
select set_masklen('1.2.3.4'::inet,24) >> '1.2.3.244'::inet;
--
⚂⚃ 100% natural