force indexed search?

From: "Nick Massaro" <NMASSARO(at)co(dot)jefferson(dot)co(dot)us>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: force indexed search?
Date: 1999-01-08 23:25:11
Message-ID: s6963183.080@gwgate.jefferson.co.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there a way to force postgresql to use indexing on a select statement containing "or"?

this SQL statement uses indexing...
SELECT name, hsno, area FROM parc WHERE pin = '40-002' ;

This SQL statement uses sequential search...

SELECT name, hsno, area FROM parc WHERE pin = '40-002' or pin = '40-106' or
pin = '40-013' ;

Browse pgsql-sql by date

  From Date Subject
Next Message kb chair 1999-01-09 10:44:28 Re: Insert composite type in table
Previous Message Jackson, DeJuan 1999-01-08 19:21:35 RE: [SQL] Case insensitive equality operator