-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Fri, 29 Feb 2008 17:30:08 -0700 "Gregory Williamson" <Gregory.Williamson@xxxxxxxxxxxxxxxx> wrote: > Joshua Drake spake thusly: > We used the now deprecated Full Text Indexing (FTI) with some > handwaving. But that was in PostgreSQL 7.4 and FTI is not in the > contrib package for some time now. See > <http://pgfoundry.org/projects/simplefti/> ... I looked at using it > in 8.1 but my "C" chops weren't up to it, and it depended heavily on > OIDs which we didn't want to use. Anyway, our business requirement > evaporated so it doesn't matter to us now. > Right but wouldn't this be solved with tsearch2 and pg_tgrm? - -- The PostgreSQL Company since 1997: http://www.commandprompt.com/ PostgreSQL Community Conference: http://www.postgresqlconference.org/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL SPI Liaison | SPI Director | PostgreSQL political pundit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHyLO+ATb/zqfZUUQRAnRlAJ0S0jrc4pSmnBcobEtZvuDkpkWzIACcDP1t Cwk/j1C2pEXWdANsyZV5f8E= =9GYn -----END PGP SIGNATURE----- ---------------------------(end of broadcast)---------------------------TIP 6: explain analyze is your friend