Postgres Pro
Downloads
Home   >   mailing lists

Creating a foreign key on the Union of two tables - Mailing list pgsql-sql

From saads@umich.edu (Saad Saeed)
Subject Creating a foreign key on the Union of two tables
Date
Msg-id a811aba0.0304061353.664e2263@posting.google.com
Whole thread Raw
Responses 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>)
List pgsql-sql
Tree view 
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 by date:

Previous
From: "Walter McGinnis"
Date:
Subject: Re: pesky plpgsql
Next
From: sylfanie@club-internet.fr (Stephane)
Date:
Subject: Re: Difficult query (for me)