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/
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 |