Postgres Pro
Downloads
Home   >   mailing lists

[PERFORM] Filter certain range of IP address. - Mailing list pgsql-performance

From Dinesh Chandra 12108
Subject [PERFORM] Filter certain range of IP address.
Date
Msg-id cfb55df0df5547ccacef2b7390381bb3@cyient.com
Whole thread Raw
Responses Re: [PERFORM] Filter certain range of IP address.  (vinny <vinny@xs4all.nl>)
List pgsql-performance
Tree view

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)| Cyient Ltd. Noida.

------------------------------------------------------------------

Mobile: +91-9953975849 | Ext 1078 |dinesh.chandra@cyient.com

Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.

 

pgsql-performance by date:

Previous
From: rverghese
Date:
Subject: Re: -EXT-Re: Table not using tsvector gin index andperformance much worse than when it uses it.
Next
From: vinny
Date:
Subject: Re: [PERFORM] Filter certain range of IP address.