[an error occurred while processing this directive]

Полнотекстовый поиск в PostgreSQL (Tsearch2)
  ALTER TABLE companies 
  ADD COLUMN fti_business tsvector;

  UPDATE companies SET fti_business = to_tsvector('default',business_model);

  VACUUM FULL ANALYZE companies;

  CREATE INDEX idx_fti_business ON companies USING gist(fti_business);

  CREATE TRIGGER tg_fti_companies 
  BEFORE UPDATE OR INSERT ON companies
  FOR EACH ROW EXECUTE PROCEDURE
    tsearch2(fti_business, business_model);

  SELECT company_name, business_model
  FROM companies
  WHERE fti_business @@
    to_tsquery('default','bushing | engine');
 
06.05.2004 , Источник: https://www.opennet.ru/opennews/art....
Ключи: postgresql, search / Лицензия: CC-BY
Раздел:    Корень / Программисту и web-разработчику / SQL и базы данных / PostgreSQL специфика / Оптимизация и администрирование PostgreSQL

[an error occurred while processing this directive]

[an error occurred while processing this directive]