I have two tables forming a parent-child relationship, in my case a child entity could appear to have multiple parent records. Given records of the parent table, I would like to perform a pairwise determination of shared children between each such pair. I am thinking of using full text search for this. If this is the right direction, is there a way to obtain the intersect of two tsvector values? Allan. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general