/usr/share/gforge/db/20111007-fti-aggregate-functions.sql is in gforge-db-postgresql 5.1.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | CREATE OR REPLACE FUNCTION ff_tsvector_add (v1 tsvector, v2 tsvector)
RETURNS tsvector
AS $$
BEGIN
RETURN v1 || v2 ;
END;
$$ LANGUAGE plpgsql
IMMUTABLE
RETURNS NULL ON NULL INPUT;
CREATE AGGREGATE ff_tsvector_agg (
basetype = tsvector,
sfunc = ff_tsvector_add,
stype = tsvector
);
|