The big job is populating the index columns. I think you can only put
the full text index column in the same table as the referenced
columns. In other words, you will end up with 3 tables, each with a
ftidx column. I hope your docs show how to create and populate the
indexes and to create triggers to keep them up to date.
To search across 3 tables I would do something like
select ...
from t1 join t2 on ... join t3 on...
where t1.idxfti @@ 'test'::tsquery
or t2.idxfti @@ 'test'::tsquery
or t2.idxfti @@ 'test'::tsquery
If there is an easier better way, I don't know it!
I can email you the very good intro and readme files directly if you need them.
On 1/19/06, Michelle Konzack <linux4michelle@freenet.de> wrote:
> Hello,
>
> because I am not in Strasbourg and have NO WEB Access I have
> following question:
> How to use tsearch2?
>
> I have load the tsearch2.sql into my Database but I do not know
> how to use it, because the Documentation under Debian is not very
> usefull.
>
> Note: I am sending messages via a GSM gateway which block any
> kind of SSL, FTP and Web access.
>
> Does anyone have some usefull examples how to search in
> three tables ("timeline", "dossiers" and "peoples") each
> three columns?
>
> Where the biggest column is in "timeline" and hold around
> 130 GByte of text/plain data.
>
> Greetings
> Michelle Konzack
> Systemadministrator
> Tamay Dogan Network
> Debian GNU/Linux Consultant
>
>
> --
> Linux-User #280138 with the Linux Counter, http://counter.li.org/
> ##################### Debian GNU/Linux Consultant #####################
> Michelle Konzack Apt. 917 ICQ #328449886
> 50, rue de Soultz MSM LinuxMichi
> 0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
"Her faults were those of her race and sex; her virtues were her own.
Farewell, and if for ever - "
-- "Travels with a Donkey in the Cevennes" by Robert Louis Stevenson