root/sql/sprocs/noit.update_metric_summary_fulltext.sql

Revision 978cc49fa9053924e4eabdf90e77664a8a8da630, 453 bytes (checked in by Denish Patel <denish@omniti.com>, 5 years ago)

updated noit.update_metric_summary_fulltext

  • Property mode set to 100644
Line 
1 -- formerly stratcon.trig_update_tsvector_from_mv_dock
2
3 CREATE OR REPLACE FUNCTION noit.update_metric_summary_fulltext()
4   RETURNS trigger AS
5 $BODY$
6 DECLARE
7 BEGIN
8     UPDATE noit.metric_name_summary SET ts_search_all=stratcon.metric_name_summary_tsvector(sid, metric_name, metric_type) WHERE sid = NEW.sid;
9    RETURN NEW;
10 END
11 $BODY$
12   LANGUAGE 'plpgsql'  SECURITY DEFINER;
13  
14 GRANT EXECUTE ON FUNCTION noit.update_metric_summary_fulltext() TO stratcon;
15
Note: See TracBrowser for help on using the browser.