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

From Trevor Talbot
Subject Re: tsearch2 in PostgreSQL 8.3?
Date
Msg-id 90bce5730708181001s684209a3ka33c15bf9e375cbe@mail.gmail.com
Whole thread Raw
In response to Re: tsearch2 in PostgreSQL 8.3?  (Bruce Momjian <bruce@momjian.us>)
Responses Re: tsearch2 in PostgreSQL 8.3?  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On 8/18/07, Bruce Momjian <bruce@momjian.us> wrote:

> Remember an expression index can be a user-created function so you can
> embed whatever you want in your function and just index it's output,
> just like you would with a trigger creating a separate column.

Well, you could create a function that returns a tsvector, but how do
you get that to work with queries?  I've been under the impression the
expressions need to match (in the normal case, be the same function
with the same arguments) in order to use the index.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: "It'd be better if there were not an implicit cast from int8 to text..."
Next
From: Tom Lane
Date:
Subject: Re: text search vs schemas