varchar_pattern_ops in 7.3.4? - Mailing list pgsql-general

From Kragen Sitaker
Subject varchar_pattern_ops in 7.3.4?
Date
Msg-id 20040121151908.J11165@fs.corp.airwave.com
Whole thread Raw
Responses Re: varchar_pattern_ops in 7.3.4?
List pgsql-general
I'd like to be able to do queries like "select count(*), fromline from
message where subject like 'Couldn%'" quickly.  I see that, in current
Postgres, I can do this with an index like "create index message_subject
on message using btree(subject varchar_pattern_ops)".  But I'm using
Postgres 7.3.4, and it doesn't seem to have varchar_pattern_ops in its
pg_opclass.opcname.  Is there an easier way to do these queries than
upgrading?

pgsql-general by date:

Previous
From: "John Gray"
Date:
Subject: Re: ORM, XPath, and pgxml_dom segfaulting
Next
From: Mike Mascari
Date:
Subject: Re: CTTAS w/ DISTINCT ON crashes backend