Creating a foreign key on the Union of two tables

Поиск
Список
Период
Сортировка
От saads@umich.edu (Saad Saeed)
Тема Creating a foreign key on the Union of two tables
Дата
Msg-id a811aba0.0304061353.664e2263@posting.google.com
обсуждение исходный текст
Ответы Re: Creating a foreign key on the Union of two tables  (Rod Taylor <rbt@rbt.ca>)
Re: Creating a foreign key on the Union of two tables  (Bruno Wolff III <bruno@wolff.to>)
Re: Creating a foreign key on the Union of two tables  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-sql
I have 2 tables "A" and "B" in mySQL. They both have an attribute 'id'
which is unique between the 2 tables. I want the union of these 2
attributes to be a foreign key in a 3rd table "C". How do I specify
this constraing in sql (mySQL) in table C? And for complex reasons I
cannot merge the 2 tables A and B.

Thanks,

-Saad



В списке pgsql-sql по дате отправления:

Предыдущее
От: "Walter McGinnis"
Дата:
Сообщение: Re: pesky plpgsql
Следующее
От: sylfanie@club-internet.fr (Stephane)
Дата:
Сообщение: Re: Difficult query (for me)