Return to Answer

• Two SQL LEFT JOINS produce incorrect result

• Two SQL LEFT JOINS produce incorrect result

Also adding separators between word to avoid false positives from matching illegally combined words, like @Daniel hinted in his comment.

Also adding separators between word to avoid false positives from matching illegally combined words, like @Daniel hinted in his comment.

I concatenate the string with concat_ws() (which ignores potential NULL values from any of the contributing sources) and call to_tsvector() only once, which should be a bit cheaper.

Using LEFT [OUTER] JOIN we don't exclude rows without relatives in the joined tables.

By aggregating multiple rows before joining we avoid the cross-multiplication of rows.

I concatenate the string with concat_ws() (which ignores potential NULL values from any of the contributing sources) and call to_tsvector() only once, which should be a bit cheaper.