Re: tsearch2 in PostgreSQL 8.3?
Trevor Talbot <quension@gmail.com>
From: "Trevor Talbot" <quension@gmail.com>
To: "Bruce Momjian" <bruce@momjian.us>
Cc: pgsql-hackers@postgresql.org, "Mike Rylander" <mrylander@gmail.com>, "tomas@tuxteam.de" <tomas@tuxteam.de>, "Josh Berkus" <josh@agliodbs.com>, "Tom Lane" <tgl@sss.pgh.pa.us>, "Oleg Bartunov" <oleg@sai.msu.su>
Date: 2007-08-18T17:01:44Z
Lists: 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.