Re: tsearch2 in PostgreSQL 8.3? - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: tsearch2 in PostgreSQL 8.3?
Date
Msg-id 87eji3v4s1.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: tsearch2 in PostgreSQL 8.3?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: tsearch2 in PostgreSQL 8.3?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Tom Lane" <tgl@sss.pgh.pa.us> writes:

> Yeah, unfortunately we overlooked the implications of the conversion to
> tsvector being environment-dependent.  Those opclasses will have to go
> away again.  AFAICS the only safe way to build an index directly on a
> text column is
>
> CREATE INDEX idxname ON tblname USING gin (to_tsvector('config', textcolumn));

Is there a null configuration which could be the default for the casts? So the
syntax would still work and would generate an index which worked well but has
no stop words, no stemming, etc?

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Decibel!
Date:
Subject: Re: Deferred Constraints
Next
From: Andrew Dunstan
Date:
Subject: Re: build farm failures