[Summary view] [Print] [Text view]

   1  CREATE OR REPLACE FUNCTION ts2_page_title()
   2  RETURNS TRIGGER
   3  LANGUAGE plpgsql AS
   4  $mw$
   5  BEGIN
   6  IF TG_OP = 'INSERT' THEN
   7    NEW.titlevector = to_tsvector('default',REPLACE(NEW.page_title,'/',' '));
   8  ELSIF NEW.page_title != OLD.page_title THEN
   9    NEW.titlevector := to_tsvector('default',REPLACE(NEW.page_title,'/',' '));
  10  END IF;
  11  RETURN NEW;
  12  END;
  13  $mw$;