In article <1257149236(dot)3426(dot)9(dot)camel(at)localhost>,
Vasiliy G Tolstov <v(dot)tolstov(at)selfip(dot)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.