On 02/24/2010 10:41 AM, Malcolm Greene wrote: > Anyone have any experience using PostgreSQL's fulltext search > capabilities? > > In particular, how easy is it to control the min word length for > what qualifies as a searchable word? > > In MySQL you can control this setting via the my.ini file entry > "ft_min_len = 3". > > Does PostgreSQL have a similar capability and is it possible to > change this behavior on a database by database basis without > having to edit a a configuration file entry that requires a > restart of the database to be recognized? >
PostgreSQL supports full text searches, but I haven't implemented it in my applications yet. I'm still using the old wild card search on fields, but plan on getting around to the full text search soon. http://www.postgresql.org/docs/8.3/static/textsearch.html Regards, LelandJ > A secondary question for our Python readers: What PostgreSQL > Python module do you recommend for Python 2.5/2.6 dual > Linux/Windows use? > > Here's the official(?) list of options to choose from: > http://wiki.python.org/moin/PostgreSQL > > Thanks! > Malcolm > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

