| From: | "Trevor Talbot" <quension(at)gmail(dot)com> |
|---|---|
| To: | "Bruce Momjian" <bruce(at)momjian(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, "Mike Rylander" <mrylander(at)gmail(dot)com>, "tomas(at)tuxteam(dot)de" <tomas(at)tuxteam(dot)de>, "Josh Berkus" <josh(at)agliodbs(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Oleg Bartunov" <oleg(at)sai(dot)msu(dot)su> |
| Subject: | Re: tsearch2 in PostgreSQL 8.3? |
| Date: | 2007-08-18 17:01:44 |
| Message-ID: | 90bce5730708181001s684209a3ka33c15bf9e375cbe@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 8/18/07, Bruce Momjian <bruce(at)momjian(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-18 17:28:01 | Re: text search vs schemas |
| Previous Message | Tom Lane | 2007-08-18 16:35:03 | Re: "It'd be better if there were not an implicit cast from int8 to text..." |