Re: tsearch2 in PostgreSQL 8.3?

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

Bruce Momjian wrote:
> Trevor Talbot wrote:
>> 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.
>
> Yes, so you create a function called complex_ts and create the index:
>
> CREATE INDEX ii on x USING GIT(complex_ts(col1, col2))

GIN?

>
> and in your WHERE clause you do:
>
> WHERE 'a & b' @@ complex_ts(col1, col2)
>

- --

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGxzHtATb/zqfZUUQRAnpFAJ0SXj1hvjxM03l35R3oWpm6TVwKEACeOwup
cfyDu6zdxf1fKcf9AE+5VSs=
=d81X
-----END PGP SIGNATURE-----