Re: tsearch_core for inclusion

From: "Magnus Hagander" <magnus(at)hagander(dot)net>
To: oleg(at)sai(dot)msu(dot)su
Cc: "Robert Treat" <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: tsearch_core for inclusion
Date: 2007-03-16 06:19:19
Message-ID: 20070316061914.01EEFDCC3EF@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Most people whom I talk to about tsearch who want the syntax changed to make
> > it easier want something akin to just "CREATE INDEX fti1 on t1(c1) USING
> > FULLTEXT" and then be done with it. This patch isn't going to give people
> > that.
>
> Since we use standard postgresql-ish CREATE INDEX command, I assume
> people want to skip creation of tsvector column ?

That would be great.

> How they could manage
> complex document indexing, when document is a combination (with different weights)
> of many text attributes from several tables, for example ?

Just to give you some more work, could I have both, please.

Seriously, if the current powerful functionality could be combined with a dead simple solution for new users and those who don't need it, that would be very
good.

This could be an auto generated hidden column or something, as long as the user doesn't need to see or care about it in the simple case.

/Magnus

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Bartunov 2007-03-16 06:56:28 Re: tsearch_core for inclusion
Previous Message tomas 2007-03-16 05:42:38 Re: My honours project - databases using dynamically attached entity-properties