force indexed search? - Mailing list pgsql-sql

From Nick Massaro
Subject force indexed search?
Date
Msg-id s6963183.080@gwgate.jefferson.co.us
Whole thread Raw
List 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' ;




pgsql-sql by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Case insensitive equality operator
Next
From: kb chair
Date:
Subject: Re: Insert composite type in table