Jay Kang wrote:
> Hello,
>
> I'm currently trying to decide on a database design for tags in my web
> 2.0 application. The problem I'm facing is that I have 3 separate tables
> i.e. cars, planes, and schools. All three tables need to interact with
> the tags, so there will only be one universal set of tags for the three
> tables.
It strikes me that some tsearch2 ts_vector like datatype might
work well for this; depending on the types of queries you're doing.