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.
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
..@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
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
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
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
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
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)|