Re: [GENERAL] How to use index in strpos function

2008-12-30 Thread Adam Rich
> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Tuan Hoang Anh > Sent: Tuesday, December 30, 2008 10:49 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] How to use index in strpos fu

[GENERAL] How to use index in strpos function

2008-12-30 Thread Tuan Hoang Anh
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 ''::c