Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Filter certain range of IP address. - Mailing list pgsql-performance

From David G. Johnston
Subject Re: [PERFORM] Filter certain range of IP address.
Date
Msg-id CAKFQuwYVgCiUsDDHc9FjVCtsDttZHNjHnukWwFz3TFtZwAj=2Q@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Filter certain range of IP address.  (Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>)
Responses Re: [PERFORM] Filter certain range of IP address.
Re: [PERFORM] Filter certain range of IP address.
List pgsql-performance
Tree view
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'

David J.
 ​

pgsql-performance by date:

Previous
From: Dinesh Chandra 12108
Date:
Subject: Re: [PERFORM] Filter certain range of IP address.
Next
From: Rick Otten
Date:
Subject: Re: [PERFORM] Filter certain range of IP address.