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!
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
