Re: Tsearch 2, index in different table?

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Tsearch 2, index in different table?
Date: 2005-12-22 18:59:39
Message-ID: 20051222185939.85906.qmail@web33302.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

--- Mag Gam <magawake(at)gmail(dot)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/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message s anwar 2005-12-23 02:48:55 Postgres 8.1 choosing the larger index for an index scan
Previous Message Tom Lane 2005-12-22 17:25:55 Re: long transaction with concurrent SELECT statements