How to use index in strpos function

[Tuan Hoang Anh <hatuan05@xxxxxxxxx>]

I have table command
CREATE TABLE command
(
 menuid0 character varying(20) NOT NULL DEFAULT ''::character varying,
 menuid character varying(20) NOT NULL DEFAULT ''::character varying,
 "text" character varying NOT NULL DEFAULT ''::character varying,
 text2 character varying NOT NULL DEFAULT ''::character varying,
 ma_ct character(3) NOT NULL DEFAULT ''::bpchar,
 report character varying NOT NULL DEFAULT ''::character varying,
 command character varying NOT NULL DEFAULT ''::character varying,
 title character varying NOT NULL DEFAULT ''::character varying,
 title2 character varying NOT NULL DEFAULT ''::character varying,
 basicright smallint NOT NULL DEFAULT 0,
 picture1 character varying NOT NULL DEFAULT ''::character varying,
 picture2 character varying NOT NULL DEFAULT ''::character varying,
 "type" character varying(2) NOT NULL DEFAULT ''::character varying,
 "sysid" character varying NOT NULL DEFAULT ''::character varying,
 syscode character varying NOT NULL DEFAULT ''::character varying,
 CONSTRAINT command_pkey PRIMARY KEY (menuid0)
)
WITH (OIDS=TRUE);
ALTER TABLE command OWNER TO postgres;

And one index

CREATE INDEX command_command
 ON command
 USING btree(upper(command));

And have a query use it
explain select * from command where strpos('APCTPN1.EXE PN1', 
UPPER(command)) > 0 AND UPPER(command) <> ''
"Seq Scan on command  (cost=100000000.00..100000015.26 rows=92 width=200)"
   "  Filter: ((upper((command)::text) <> ''::text) AND 
(strpos('APCTPN1.EXE PN1'::text, upper((command)::text)) > 0))"

This command is called a lot, so i want to use index in it. How to use 
index on this command

Thanks a lot.
Sorry for my English

Tuan Hoang Anh



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general