Re: Comparing first 3 numbers of a IPv4 address?

Hey Tom,

Thanks for you solution!

2010/11/20 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> Alexander Farber <alexander(dot)farber(at)gmail(dot)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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

--
// Dmitriy.