Revision a27cd9b462a686609eff744d1e6553da5605090b, 482 bytes
(checked in by Depesz Lubaczewski <depesz@omniti.com>, 9 years ago)
|
prism procedures, and simple tool to split pg_dump -n prism -s output into many files
|
- Property mode set to
100644
|
Line | |
---|
1 |
CREATE OR REPLACE FUNCTION prism.trig_update_tsvector_saved_graphs() RETURNS trigger |
---|
2 |
AS $$ |
---|
3 |
DECLARE |
---|
4 |
ref_title text; |
---|
5 |
BEGIN |
---|
6 |
IF TG_OP = 'UPDATE' THEN |
---|
7 |
NEW.ts_search_all=prism.saved_graphs_tsvector(NEW.graphid); |
---|
8 |
ELSE |
---|
9 |
ref_title:=coalesce(replace(NEW.title, '.', ' '), ' '); |
---|
10 |
NEW.ts_search_all =to_tsvector(ref_title); |
---|
11 |
END IF; |
---|
12 |
RETURN NEW; |
---|
13 |
END |
---|
14 |
$$ |
---|
15 |
LANGUAGE plpgsql; |
---|
16 |
|
---|
17 |
|
---|
18 |
ALTER FUNCTION prism.trig_update_tsvector_saved_graphs() OWNER TO reconnoiter; |
---|