In article <1257149236.3426.9.ca...@localhost>,
Vasiliy G Tolstov <v.tols...@selfip.ru> writes:

> Hello. 
> I have table with cidr data type column (table is white/black list of
> networks).

> Does it possible to query - is the some address contains in any cidr
> network in this table? (for all networks in the table do "contains or
> equals"
> http://www.postgresql.org/docs/8.4/interactive/functions-net.html
> )

If you mess with IP addresses, you should have a look at the ip4r
contrib module.  Since I discovered it, I've never looked back at
cidr/inet.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to