3 INSERT INTO config.upgrade_log (version) VALUES ('0034'); -- miker
5 CREATE OR REPLACE FUNCTION oils_tsearch2 () RETURNS TRIGGER AS $$
12 IF TG_TABLE_NAME::TEXT ~ 'field_entry$' THEN
14 SELECT n.func AS func,
16 FROM config.index_normalizer n
17 JOIN config.metabib_field_index_norm_map m ON (m.norm = n.id)
18 WHERE field = NEW.field
21 EXECUTE 'SELECT ' || normalizer.func || '(' || quote_literal( value ) || ',' || BTRIM(normalizer.params,'[]') || ')' INTO value;
25 IF REGEXP_REPLACE(VERSION(),E'^.+?(\\d+\\.\\d+).*?$',E'\\1')::FLOAT > 8.2 THEN
26 NEW.index_vector = to_tsvector((TG_ARGV[0])::regconfig, value);
28 NEW.index_vector = to_tsvector(TG_ARGV[0], value);