On Wed, 2005-08-17 at 13:40 -0700, Bill Moseley wrote:
> a course
> and class share so many columns. ...and
> I worry about changing a column type on one table and forgetting to
> change it on the other table.
Postgres types might help here. You could probably create a type that
contains the common columns, and then embed that type where you need it.
---------------------------(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
