Re: [GENERAL] cidr data type question

2009-11-02 Thread Vasiliy G Tolstov
В Пнд, 02/11/2009 в 13:29 +0100, Harald Fuchs пишет: > In article <1257149236.3426.9.ca...@localhost>, > Vasiliy G Tolstov 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

Re: [GENERAL] cidr data type question

2009-11-02 Thread Harald Fuchs
In article <1257149236.3426.9.ca...@localhost>, Vasiliy G Tolstov 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

Re: [GENERAL] cidr data type question

2009-11-02 Thread Vasiliy G Tolstov
В Пнд, 02/11/2009 в 00:34 -0800, John R Pierce пишет: > Vasiliy G Tolstov wrote: > > 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 netw

Re: [GENERAL] cidr data type question

2009-11-02 Thread John R Pierce
Vasiliy G Tolstov wrote: 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

[GENERAL] cidr data type question

2009-11-02 Thread Vasiliy G Tolstov
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.h