projects
/
fusionforge
/
fusionforge.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
project home
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Remove stripcslashes
[fusionforge/fusionforge.git]
/
src
/
db
/
20111007-fti-aggregate-functions.sql
1
CREATE OR REPLACE FUNCTION ff_tsvector_add (v1 tsvector, v2 tsvector)
2
RETURNS tsvector
3
AS $$
4
BEGIN
5
RETURN v1 || v2 ;
6
END;
7
$$ LANGUAGE plpgsql
8
IMMUTABLE
9
RETURNS NULL ON NULL INPUT;
10
11
CREATE AGGREGATE ff_tsvector_agg (
12
basetype = tsvector,
13
sfunc = ff_tsvector_add,
14
stype = tsvector
15
);