Index scan on CIDR field ? - Mailing list pgsql-sql

From Margarit Nickolov
Subject Index scan on CIDR field ?
Date
Msg-id 199912290846.KAA19677@school.digsys.bg
Whole thread Raw
Responses Re: [NOVICE] Index scan on CIDR field ?
List pgsql-sql
I created index on CIDR field on table with about 1 000 000 rows, made 
'vacuum analyze', but exlain told me that sequental scan is doneon query like that SELECT * FROM table WHERE
ipaddr='212.129.92.1'
 I'm using PostgreSQL 6.5.1. I need a index scan. Do I miss something ?
Margarit.



pgsql-sql by date:

Previous
From: wieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] Oracle sql queries
Next
From: Margarit Nickolov
Date:
Subject: Index scan on CIDR field ?