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.chan...@cyient.com<mailto:%7cdinesh.chan...@cyient.com> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. From: Rick Otten [mailto:rottenwindf...@gmail.com] Sent: 07 April, 2017 9:26 PM To: David G. Johnston <david.g.johns...@gmail.com> Cc: Dinesh Chandra 12108 <dinesh.chan...@cyient.com>; vinny <vi...@xs4all.nl>; pgsql-performance-ow...@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.johns...@gmail.com<mailto:david.g.johns...@gmail.com>> wrote: On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 <dinesh.chan...@cyient.com<mailto:dinesh.chan...@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'; if ip_addr is an inet data type -- https://www.postgresql.org/docs/9.6/static/functions-net.html
