Re: [PERFORM] Filter certain range of IP address.

Поиск
Список
Период
Сортировка
От Rick Otten
Тема Re: [PERFORM] Filter certain range of IP address.
Дата
Msg-id CAMAYy4K_SJPJgZ9trUmkJhjnyY7rac0JDCDzhdDYZbL0foW5Ag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Filter certain range of IP address.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [PERFORM] Filter certain range of IP address.  (Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>)
Re: [PERFORM] Filter certain range of IP address.  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Список pgsql-performance
Дерево обсуждения


On Fri, Apr 7, 2017 at 11:29 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com> wrote:
Dear Vinny,

Thanks for your valuable replay.

but I need a select query, which select only that record which starts from IP "172.23.110" only from below table.

xxx     172.23.110.175
yyy     172.23.110.178
zzz     172.23.110.177
aaa     172.23.110.176
bbb     172.23.111.180
ccc     172.23.115.26

​SELECT ... WHERE substring(ip_addr::text, 1, 10) = '172.23.110'

or
   select ... where ip_addr << '172.23.110/32';


В списке pgsql-performance по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [PERFORM] Filter certain range of IP address.
Следующее
От: Dinesh Chandra 12108
Дата:
Сообщение: Re: [PERFORM] Filter certain range of IP address.