Thanks. It’s working fine. Thank you so much
Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida. ------------------------------------------------------------------ Mobile: +91-9953975849 | Ext 1078 |[email protected]<mailto:%[email protected]> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. From: Rick Otten [mailto:[email protected]] Sent: 07 April, 2017 9:26 PM To: David G. Johnston <[email protected]> Cc: Dinesh Chandra 12108 <[email protected]>; vinny <[email protected]>; [email protected]; [email protected] Subject: Re: [PERFORM] Filter certain range of IP address. On Fri, Apr 7, 2017 at 11:29 AM, David G. Johnston <[email protected]<mailto:[email protected]>> wrote: On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 <[email protected]<mailto:[email protected]>> 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
