> > Now see, this is exactly the kind of sagely advice I was hoping for! :) > > I'll look into tsearch2, and failing that for some reason, I love the > keyword table idea.
For example keyword search code, you can try this package: http://downloads.sourceforge.net/cascade/cascade-devel-pieces-1.1.tgz?modtime=999556617&big_mirror=0 There is a "keywords" subdirectory with the Perl and SQL. I'm sure this code is not ideal in a number of ways: 1. It's from 2001. 2. It doesn't actually function on it's own anymore. However, you can read the code and get ideas. 3. I'm sure someone has a better looking/functioning example! Anyway, it's there if you want to take a look. Mark ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
