Re: TSEARCH2: disable stemming in indexes and triggers - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: TSEARCH2: disable stemming in indexes and triggers
Date
Msg-id 465F137A.9010002@sigaev.ru
Whole thread Raw
In response to TSEARCH2: disable stemming in indexes and triggers  (Erwin Moller <erwin@darwine.nl>)
Responses Re: TSEARCH2: disable stemming in indexes and triggers
List pgsql-general
> I found out that using 'simple' instead of 'default' when using
> to_tsvector() does excactly that, but I don't know how to change my
> triggers and indexes to keep doing the same (using 'simple').

Suppose, your database is initialized with C locale. So, just mark
simple configuration as default:

# update pg_ts_cfg set locale=null where ts_name='default';
# update pg_ts_cfg set locale='C' where ts_name='simple';

If your locale setting is not C then mark needed configuration with your
  locale.

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: TSEARCH2: disable stemming in indexes and triggers
Next
From: Anton
Date:
Subject: how to use array with "holes" ?