Received: from www.co.jefferson.co.us (www.co.jefferson.co.us [199.184.241.188]) by hub.org (8.9.1/8.9.1) with ESMTP id SAA04633 for ; Fri, 8 Jan 1999 18:25:37 -0500 (EST) (envelope-from NMASSARO@co.jefferson.co.us) Received: from gwgate.jefferson.co.us (gwgate [172.16.8.3]) by www.co.jefferson.co.us (8.9.1/8.9.1) with SMTP id QAA05693 for ; Fri, 8 Jan 1999 16:24:20 -0700 Received: from GWGC2-Message_Server by gwgate.jefferson.co.us with Novell_GroupWise; Fri, 08 Jan 1999 16:25:39 -0700 Message-Id: X-Mailer: Novell GroupWise 5.5 Date: Fri, 08 Jan 1999 16:25:11 -0700 From: "Nick Massaro" To: Subject: force indexed search? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id SAA04635 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' ;