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?

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to