In your example can you Make cx.r a foreign key on another table (say real) so
that a valid instance of cx must have a value for r that exists in real? I
guess you could make r an enum but that wouldn't readily allow you to modify
the allowable values for r. A domain and/or check constraint fo
Vincent De Groote writes:
> I have a composite type with 2 fields. I would like to check that one
> of these fields exists in another table.
> Foreign keys on a composite field does not seem to be supported.
Works for me, in 8.4 and up. Whether it's a good idea is a different
issue (I think it'
Hello,
I have a composite type with 2 fields. I would like to check that one
of these fields exists in another table.
Foreign keys on a composite field does not seem to be supported.
Is there another way to do that ?
Thanks for your reply
Vincent De Groote
