Re: Comparing first 3 numbers of a IPv4 address? - Mailing list pgsql-general

Alexander Farber <alexander.farber@gmail.com> writes:
> 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?

regression=# select network(set_masklen('123.45.67.42'::inet, 24)) =
regression-#  network(set_masklen('123.45.67.56'::inet, 24));
 ?column?
----------
 t
(1 row)


            regards, tom lane