Re: Tsearch 2, index in different table? - Mailing list pgsql-novice

From
Subject Re: Tsearch 2, index in different table?
Date
Msg-id 20051222185939.85906.qmail@web33302.mail.mud.yahoo.com
Whole thread Raw
In response to Tsearch 2, index in different table?  (Mag Gam <magawake@gmail.com>)
List pgsql-novice
--- Mag Gam <magawake@gmail.com> wrote:

> Trying this post again, since I can't post on
> pgsql-general....
>
> Is it possible to store an index in a different
> table? Instead of
> keeping the index in a separate column, I have a
> separate table for
> storing all indexes. I am trying to set up something
> like this:
>
> UPDATE indexTable SET
>
index1=to_tsvector('default',coalesce(Table1.Data,''));

Mag, i don't have any input how to do this, but i am
curious as to what motivated you to set up an index
table in this manner.

will you share your motivation here?

tia...

OE1




__________________________________
Yahoo! for Good - Make a difference this year.
http://brand.yahoo.com/cybergivingweek2005/

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: long transaction with concurrent SELECT statements
Next
From: s anwar
Date:
Subject: Postgres 8.1 choosing the larger index for an index scan