Re: cidr data type question
От
Vasiliy G Tolstov
Тема
Re: cidr data type question
Дата
Msg-id
1257165286.3426.120.camel@localhost
Ответ на
Re: cidr data type question (Harald Fuchs)
Список
Дерево обсуждения
Re: cidr data type question Harald Fuchs <hari.fuchs@gmail.com>
Re: cidr data type question Vasiliy G Tolstov <v.tolstov@selfip.ru>
В Пнд, 02/11/2009 в 13:29 +0100, Harald Fuchs пишет: > In article <1257149236.3426.9.camel@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 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. > > Thank's but cidr solved fine my task -- Vasiliy G Tolstov Selfip.Ru
В списке pgsql-general по дате отправления