Re: Comparing first 3 numbers of a IPv4 address?

[Dmitriy Igrishin <dmitigr@xxxxxxxxx>]

Hey Tom,

Thanks for you solution!

2010/11/20 Tom Lane <tgl@xxxxxxxxxxxxx>

Alexander Farber <alexander.farber@xxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

-- 
// Dmitriy.