Hey Tom, Thanks for you solution!
2010/11/20 Tom Lane <[email protected]> > Alexander Farber <[email protected]> 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 ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- // Dmitriy.
