3 -- Create new expression type for IS [NOT] NULL
5 INSERT INTO config.upgrade_log (version) VALUES ('0271'); -- miker
7 UPDATE config.metabib_field_index_norm_map
8 SET params = REPLACE(params,E'\'','"')
9 WHERE params IS NOT NULL AND params <> '';
11 CREATE OR REPLACE FUNCTION oils_tsearch2 () RETURNS TRIGGER AS $$
16 IF NEW.index_vector = ''::tsvector THEN
22 IF TG_TABLE_NAME::TEXT ~ 'field_entry$' THEN
24 SELECT n.func AS func,
25 n.param_count AS param_count,
27 FROM config.index_normalizer n
28 JOIN config.metabib_field_index_norm_map m ON (m.norm = n.id)
29 WHERE field = NEW.field
32 EXECUTE 'SELECT ' || normalizer.func || '(' ||
33 quote_literal( value ) ||
35 WHEN normalizer.param_count > 0
36 THEN ',' || REPLACE(REPLACE(BTRIM(normalizer.params,'[]'),E'\'',E'\\\''),E'"',E'\'')
43 IF REGEXP_REPLACE(VERSION(),E'^.+?(\\d+\\.\\d+).*?$',E'\\1')::FLOAT > 8.2 THEN
44 NEW.index_vector = to_tsvector((TG_ARGV[0])::regconfig, value);
46 NEW.index_vector = to_tsvector(TG_ARGV[0], value);