I am thinking about how to model tags for a web site in the database.
(Each site entry is assigned a number of tags and a match can then later
be performed between these tags and tags entered by the visitor).
Is tsearch2 the way to do it? Each site entry could then store its tags
in a tsvector. That would make me able to perform partial matches and
rate them.
Or how would you model tags in the database?