Re: full text searching
Gunnar R|nning <gunnar@candleweb.no>
From: Gunnar R|nning <gunnar@candleweb.no>
To: "Mitch Vincent" <mitch@venux.net>
Cc: "Culley Harrelson" <culleyharrelson@yahoo.com>, <pgsql-general@postgresql.org>
Date: 2001-02-06T13:29:33Z
Lists: pgsql-hackers
"Mitch Vincent" <mitch@venux.net> writes: > -- Isn't going to catch anything but the literal string "woman".. (it's case > sensitive too, mind you) > > SELECT * from people WHERE whatever LIKE 'wom%n'; > > -- Should check either. Well you wouldn't want to start building these kind of rules in your application - better to have them in the search engine. The fulltextindex in the contrib package does of course not offer anything like this, it would be nice to see a third party addon provide fulltext capabilities for Postgresql. regards, Gunnar