Design Table & Search Question - Mailing list pgsql-general

From Gabriel Laet
Subject Design Table & Search Question
Date
Msg-id 1180551544.139880.271180@g4g2000hsf.googlegroups.com
Whole thread Raw
Responses Re: Design Table & Search Question
Re: Design Table & Search Question
List pgsql-general
Hi,

I'm developing an application where basically I need to store cars.
Every car has a Make and Model association. Right now, I have three
tables: MAKE, MODEL (make_id) and CAR (model_id).

1) I'm not sure if I need or not to include "make_id" to the CAR
table. To me, it's clear to associate just the Model. Am I right?

2) I'm thinking in the best way to search content. I'll need to search
data across multiple-tables, and I'm not sure about the best way to do
that. Should I use TSearch2 or just a bunch of LIKEs and JOINs
statements?

I appreciate any help :)
Thanks!


pgsql-general by date:

Previous
From: "Zhan Deng"
Date:
Subject: Problems with createdb.exe and createuser.exe
Next
From: "Vang"
Date:
Subject: current transaction is aborted, commands ignored until end of transaction block