toots

CREATE OR REPLACE FUNCTION concat_tsvectors(tsv1 tsvector, tsv2 tsvector)
RETURNS tsvector AS $$
BEGIN
  RETURN coalesce(tsv1, to_tsvector('default', ''))
      || coalesce(tsv2, to_tsvector('default', ''));
END;
$$ LANGUAGE plpgsql;

CREATE AGGREGATE tsvector_agg (
  BASETYPE = tsvector,