1 CREATE OR REPLACE FUNCTION update_wiki_page() RETURNS trigger
6 SELECT setweight(to_tsvector(wpr.text), 'D') AS ts
8 FROM wiki_page_revisions wpr
9 WHERE NEW.wprev = wpr.wprev;
10 NEW.textsearch := rec.ts
11 || setweight(to_tsvector(NEW.namespace || ':' || NEW.name), 'A');