Foreign key in composite values

From: Vincent De Groote <vdg(dot)encelade(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Foreign key in composite values
Date: 2011-05-06 09:36:14
Message-ID: 1304674574.4709.24.camel@portable-vdg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Asfand Qazi (Sanger Institute) 2011-05-06 10:22:09 Re: Generating fields in views with search/replace?
Previous Message Cédric Villemain 2011-05-06 09:12:52 Re: undead index