Hey Tom,
Thanks for you solution!
2010/11/20 Tom Lane <t...@sss.pgh.pa.us>
> Alexander Farber <alexander.far...@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
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
// Dmitriy.
