Re: [GENERAL] many junction tables

2001-09-05 Thread Arne Weiner
Oh, Ok. Now I understand. It seems that there is no solution using SQL without using inheritance. I had some Ideas but postgres has weird sematics (not conforming SQL99) using inheritance and so it didn't work. But you should not - as you suggested - store the tablenames in a "assocciation" tab

[GENERAL] many junction tables

2001-09-04 Thread Eric Kolve
I was wondering if anyone has a solution to the following problem. I have a few tables similar to the following. person_table city_table company_table If I want to associate a person with a one or more cities. I need to create a city_persons table that contains just the primary keys of bo