Re: default_text_search_config and expression indexes

From: tomas(at)tuxteam(dot)de
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: tomas(at)tuxteam(dot)de, Bruce Momjian <bruce(at)momjian(dot)us>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: default_text_search_config and expression indexes
Date: 2007-08-09 18:04:18
Message-ID: 20070809180418.GB32082@www.trapp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, Aug 09, 2007 at 02:03:13PM +0400, Oleg Bartunov wrote:
> On Thu, 9 Aug 2007, tomas(at)tuxteam(dot)de wrote:
>
> >Maybe I'm missing something [...]

> I'm tired to repeat - index itself doesn't know about configuration !
> It just index tsvector data type. tsvector in turn can be obtained
> using various ways:
> 1. manually
> 2. to_tsvector
>
> tsvector can be stored in a separate attribute or be fully virtual
> like in expressional index.
>
> Moreover, tsvector can be obtained using various configurations depending
> on your application.

Yep. I think I got that.

Now what will be the "normal" case for a new user?

* build an index with a virtual tsvector (using a configuration).
Then I would expect the "index" to know the "whole" function to
calculate its entries -- that would include the config used.

This would be more "compatible" with the approach stated elsewhere to
always mention explicitly the config.

* manually. Would a novice do that? Or is that advanced stuff?

Regards -- and sorry for my stupid questions :)

- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFGu1ciBcgs9XrR2kYRAnVqAJ9mSc463I44JxLLDPpUZ/JirUVH5ACeOhUr
2/4aXs0ukMnvP8YCq8pamwQ=
=IgfC
-----END PGP SIGNATURE-----

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Tom Copeland 2007-08-09 22:46:22 MySQL Enterprise Server source code
Previous Message Joshua D. Drake 2007-08-09 16:47:32 Re: EnterpriseDB Postgres

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-08-09 18:06:36 Re: crypting prosrc in pg_proc
Previous Message Tom Lane 2007-08-09 17:58:21 Re: change name of redirect_stderr?