Re: Making Complicated References

How about some table definitions?

(amazing! what everyone else asked me for before they'd help me when **I** first
got here, now I ask others to supply :-)

Bruno Wolff III wrote:
> On Sun, Mar 30, 2003 at 03:06:46 +0000,
> "Daniel R. Anderson" <dan(at)mathjunkies(dot)com> wrote:
>
>>Hi all,
>>
>>I have tables A, B, and C. foo within Table B & C references foo in
>>table A. I want bar in table C to reference bar in table B -- but I
>>want it to reference only those bars in B with a foo that is the same.
>>
>>Is that possible?
>
>
> If foo + bar is a candidate key for B, then you can use a multicolumn
> foriegn key. If foo + bar isn't a candidate key for B, then I think you
> will need to explain more about what you are trying to do.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>