https://www.opennet.ru/openforum/vsluhforumID3/38482.html ALTER TABLE companies <br> ADD COLUMN fti_business tsvector;<br><br> UPDATE companies SET fti_business = to_tsvector('default',business_model);<br><br> VACUUM FULL ANALYZE companies;<br><br> CREATE INDEX idx_fti_business ON companies USING gist(fti_business);<br><br> CREATE TRIGGER tg_fti_companies <br> BEFORE UPDATE OR INSERT ON companies<br> FOR EACH ROW EXECUTE PROCEDURE<br> tsearch2(fti_business, business_model);<br><br> SELECT company_name, business_model<br> FROM companies<br> WHERE fti_business @@<br> to_tsquery('default','bushing &#124; engine');<br><br>URL: http://www.opennet.ru/opennews/art.shtml?num=3801<br>Обсуждается: http://www.opennet.ru/tips/info/677.shtml<br> https://www.opennet.ru/openforum/vsluhforumID3/38482.html#1 Fri, 21 Sep 2007 13:07:59 GMT не плохо было бы указывать версию PostgreSQL. начиная с 8.2 там все сильно изменилось с tsearch2...<br>