In article <1257149236.3426.9.camel@localhost>, Vasiliy G Tolstov <v.tolstov@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
