| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com> |
| Cc: | vinny <vinny(at)xs4all(dot)nl>, "pgsql-performance-owner(at)postgresql(dot)org" <pgsql-performance-owner(at)postgresql(dot)org>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Filter certain range of IP address. |
| Date: | 2017-04-07 15:29:29 |
| Message-ID: | CAKFQuwYVgCiUsDDHc9FjVCtsDttZHNjHnukWwFz3TFtZwAj=2Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 <
Dinesh(dot)Chandra(at)cyient(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rick Otten | 2017-04-07 15:56:18 | Re: Filter certain range of IP address. |
| Previous Message | Dinesh Chandra 12108 | 2017-04-07 15:18:58 | Re: Filter certain range of IP address. |