Thank you. Or maybe also? (author_ip & '255.255.255.0'::inet) = (_author_ip & '255.255.255.0'::inet)
On Sat, Nov 20, 2010 at 4:47 PM, Tom Lane <[email protected]> wrote: > 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) >| -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
