Show
Ignore:
Timestamp:
10/02/09 19:14:29 (5 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1254510869 +0000
git-parent:

[89da11dfe1603e9e3dd239922a65372058f925fe]

git-author:
Denish Patel <denish@omniti.com> 1254510869 +0000
Message:

updated noit.update_metric_summary_fulltext

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/sprocs/noit.update_metric_summary_fulltext.sql

    r89da11d r978cc49  
    11-- formerly stratcon.trig_update_tsvector_from_mv_dock 
     2 
     3CREATE OR REPLACE FUNCTION noit.update_metric_summary_fulltext() 
     4  RETURNS trigger AS 
     5$BODY$ 
     6DECLARE 
     7BEGIN 
     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; 
     10END 
     11$BODY$ 
     12  LANGUAGE 'plpgsql'  SECURITY DEFINER; 
     13  
     14GRANT EXECUTE ON FUNCTION noit.update_metric_summary_fulltext() TO stratcon; 
     15