Changeset f67c8f851568c1e75293edbe51cd405f940bab8b

Show
Ignore:
Timestamp:
11/20/08 23:03:02 (5 years ago)
Author:
Denish Patel <denish@omniti.com>
git-committer:
Denish Patel <denish@omniti.com> 1227222182 +0000
git-parent:

[171b238ecff83fa463f5add5b098378f096f8a80]

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

updated saved_graphs before i/u trigger function

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/reconnoiter_ddl_dump.sql

    rd4547fc rf67c8f8  
    765765    AS $$ 
    766766DECLARE 
     767ref_title text; 
    767768 BEGIN 
    768769 IF TG_OP = 'UPDATE' THEN 
    769    IF (NEW.graph_tags <> OLD.graph_tags OR NEW.title <> OLD.title) THEN 
    770            NEW.ts_search_all=prism.saved_graphs_tsvector(NEW.graphid);  
    771    END IF;     
    772  ELSE 
    773      NEW.ts_search_all = to_tsvector(NEW.title);  
    774  END IF;   
     770              NEW.ts_search_all=prism.saved_graphs_tsvector(NEW.graphid);  
     771  ELSE 
     772      ref_title:=coalesce(replace(NEW.title, '.', ' '), ' '); 
     773     NEW.ts_search_all =to_tsvector(ref_title);  
     774  END IF;   
    775775   RETURN NEW; 
    776776END