Function concat

Concatenates 2 text search vectors and updates the positions of word stems.

concat(tsv_1 TSVECTOR, tsv_2 TSVECTOR) RETURNS TSVECTOR

SELECT set_curcfg('default');
 
 set_curcfg
------------

(1 row)

SELECT to_tsvector('PostgreSQL is a database.');
    
    to_tsvector
--------------------
 'postgresql':1 'databas':4
(1 row)

SELECT to_tsvector('Linux is an operating system.');
          
	  to_tsvector
-------------------------------
 'oper':4 'linux':1 'system':5
(1 row)

SELECT concat(to_tsvector('PostgreSQL is a database.') , 
              to_tsvector('Linux is an operating system.'));
                      
		      concat
--------------------------------------------------
 'postgresql':1 'oper':8 'linux':5 'system':9 'databas':4
(1 row)