In response to Hari, Balaji :
> Hi,
>
>
>
> I am relatively new to PostgreSQL(8.1) and facing the following problem.
Sure? 8.1? Your explain looks like 8.2 or 8.3. 8.3 contains a
full-text-search.
If really not 8.3 you can use tsearch2, it is a contrib-module.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net