Communities for your favorite technologies. Explore all Collectives
Stack Overflow for Teams is now called Stack Internal. Bring the best of human thought and AI automation together at your work.
Bring the best of human thought and AI automation together at your work. Learn more
Find centralized, trusted content and collaborate around the technologies you use most.
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
That would be a simple join between the tables:
SELECT t2.* FROM t1 JOIN t2 ON to_tsvector(t2.tags) @@= to_tsquery(t1.word);word;
No need for full text search!
SELECT t2.* FROM t1 JOIN t2 ON to_tsvector(t2.tags) @@ to_tsquery(t1.word);
SELECT t2.* FROM t1 JOIN t2 ON t2.tags = t1.word;
