So you have three tables:
> T product_base
> T revision
> T product_revision
I don't understand the difference between revision and product revision.
Maybe product_revision is a cross reference of the first two tables?
What kind of queries would you make? I don't really see the sense of
asking what products have a revision 4. What are these products anyway?
Maybe it would make sense to ask who uses a product a revision 4 level,
but you don't have a users table.
I think we need more info as to what you are trying to do.
Strange Brew (brew(at)theMode(dot)com)
Check out my Stock Option Covered Call website http://www.callpix.com
and my Musician's Online Database Exchange http://www.TheMode.com
In response to
pgsql-novice by date
|Next:||From: Kevin Crenshaw||Date: 2005-02-16 13:54:32|
|Subject: Re: Revision Control|
|Previous:||From: Tom Lane||Date: 2005-02-16 05:18:31|
|Subject: Re: Failure to Start Postmaster/postgres |