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

Поиск
Список
Период
Сортировка
От Dinesh Chandra 12108
Тема Re: [PERFORM] Filter certain range of IP address.
Дата
Msg-id 3bd3bf63ae474b899a5dd127d668ccfe@cyient.com
обсуждение исходный текст
Ответ на Re: [PERFORM] Filter certain range of IP address.  (Rick Otten <rottenwindfish@gmail.com>)
Список pgsql-performance
Дерево обсуждения

Thanks.

 

It’s working fine.

Thank you so much

 

Regards,

Dinesh Chandra

|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.

------------------------------------------------------------------

Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com

Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.

 

From: Rick Otten [mailto:rottenwindfish@gmail.com]
Sent: 07 April, 2017 9:26 PM
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>; vinny <vinny@xs4all.nl>; pgsql-performance-owner@postgresql.org; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Filter certain range of IP address.

 

 

 

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 по дате отправления: