[Summary view] [Print] [Text view]

   1  -- Should be run on Postgres 8.3 or newer to remove the 'default'
   2  
   3  CREATE OR REPLACE FUNCTION ts2_page_title()
   4  RETURNS TRIGGER
   5  LANGUAGE plpgsql AS
   6  $mw$
   7  BEGIN
   8  IF TG_OP = 'INSERT' THEN
   9    NEW.titlevector = to_tsvector(REPLACE(NEW.page_title,'/',' '));
  10  ELSIF NEW.page_title != OLD.page_title THEN
  11    NEW.titlevector := to_tsvector(REPLACE(NEW.page_title,'/',' '));
  12  END IF;
  13  RETURN NEW;
  14  END;
  15  $mw$;
  16  
  17  CREATE OR REPLACE FUNCTION ts2_page_text()
  18  RETURNS TRIGGER
  19  LANGUAGE plpgsql AS
  20  $mw$
  21  BEGIN
  22  IF TG_OP = 'INSERT' THEN
  23    NEW.textvector = to_tsvector(NEW.old_text);
  24  ELSIF NEW.old_text != OLD.old_text THEN
  25    NEW.textvector := to_tsvector(NEW.old_text);
  26  END IF;
  27  RETURN NEW;
  28  END;
  29  $mw$;