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); ------------------------------------------------------------------ http://www.postgresql.org/docs/8.0/interactive/indexes-opclass.html ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend