Search Postgresql Archives

Modelling tags

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux