On Mon, 14 Feb 2005, Ivan Voras wrote:

> Stephan Szabo wrote:
> > You can also create an index using a <typename>_pattern_ops operator
> > class which should be usable even with other collations.
> Could you give me an example for this, or point me to the relevant
> documentation?

Basically, you could have something like:

create table test_table(a text);
create index test_index on test_table(a text_pattern_ops);



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to