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

2017-04-10 Thread vinny
On 2017-04-07 17:29, David G. Johnston wrote: On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 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.

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

2017-04-07 Thread Moreno Andreo
Il 07/04/2017 17:56, Rick Otten ha scritto: On Fri, Apr 7, 2017 at 11:29 AM, David G. Johnston wrote: On Fri, Apr 7, 2017 at

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

2017-04-07 Thread Dinesh Chandra 12108
..@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, 2

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

2017-04-07 Thread Rick Otten
On Fri, Apr 7, 2017 at 11:29 AM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 < > dinesh.chan...@cyient.com> wrote: > >> Dear Vinny, >> >> Thanks for your valuable replay. >> >> but I need a select query, which select only that

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

2017-04-07 Thread David G. Johnston
On Fri, Apr 7, 2017 at 8:18 AM, Dinesh Chandra 12108 < 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

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

2017-04-07 Thread Dinesh Chandra 12108
305,India. -Original Message- From: vinny [mailto:vi...@xs4all.nl] Sent: 07 April, 2017 7:52 PM To: Dinesh Chandra 12108 <dinesh.chan...@cyient.com> Cc: pgsql-performance-ow...@postgresql.org; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Filter certain range of IP address. On

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

2017-04-07 Thread vinny
On 2017-04-07 16:13, Dinesh Chandra 12108 wrote: Hi expert, May I know how to select a range of IP address. Example: I have number of different-2 IP's present in a table. I HAVE TO SELECT ONLY THAT IP ADDRESS WHICH DOES NOT START FROM PREFIX “172.23.110”. Thanks in advance REGARDS, DINESH

[PERFORM] Filter certain range of IP address.

2017-04-07 Thread Dinesh Chandra 12108
Hi expert, May I know how to select a range of IP address. Example: I have number of different-2 IP's present in a table. I have to select only that IP address which does not start from prefix "172.23.110". Thanks in advance Regards, Dinesh Chandra |Database administrator (Oracle/PostgreSQL)|