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