Re: How does the tsearch configuration get selected?

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Gregory Stark <stark(at)enterprisedb(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Michael Paesold <mpaesold(at)gmx(dot)at>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How does the tsearch configuration get selected?
Date: 2007-06-15 20:08:02
Message-ID: 4672F1A2.1030505@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

> To support this sanely though wouldn't you need to know which language rule a
> tsvector was generated with? Like, have a byte in the tsvector tagging it with
> the language rule forever more?

No. As corner case, dictionary might return just a number or a hash value.

>
> What I'm wondering about is if you use a different rule than what was used
> when an index entry was inserted will you get different results using the
> index than you would doing a sequential scan and reapplying the operator to
> every datum?

Rules are apllyed during creattion of tsvector, not during indexing of
tsvectors. So, sequential and index scan will return identical results.

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Bruce Momjian 2007-06-16 17:29:57 Re: How does the tsearch configuration get selected?
Previous Message Gregory Stark 2007-06-15 19:55:57 Re: How does the tsearch configuration get selected?

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-06-15 20:13:01 Re: Load Distributed Checkpoints test results
Previous Message Gregory Stark 2007-06-15 19:55:57 Re: How does the tsearch configuration get selected?