Received: from pcr.ca (www.pcr.ca [207.139.158.13] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id VAA52405 for ; Sun, 9 Jan 2000 21:34:44 -0500 (EST) (envelope-from admin@wtbwts.com) Received: by pcr.ca (Postfix, from userid 1000) id A20AA1FE8; Sun, 9 Jan 2000 21:33:31 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by pcr.ca (Postfix) with ESMTP id 8EDF01F91 for ; Sun, 9 Jan 2000 21:33:31 +0000 (GMT) Date: Sun, 9 Jan 2000 21:33:31 +0000 (GMT) From: admin X-Sender: admin@server.b0x.com To: pgsql-sql@postgresql.org Subject: can't seem to use index Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII I'm trying to use an index on a varchar(32) field, but explain keeps retuning a sequential scan. This is my table and index: CREATE TABLE manufacturer ( id int2, name varchar(32) ); CREATE INDEX manu_name_idx ON "manufacturer" using btree ( "name" "text_ops" ); Both my table and index have been created successfully, and the database has been vacuumed. Then I run the following query from the psql command-line: explain select * from manufacturer where name='3COM'; ... and I get a sequential scan! What gives? Any suggestions would be greatly appreciated, Marc