Belka Lambda <lambda-belka@xxxxxxxxx> writes: > Is there a way to construct FOREIGN KEYs from parts of composite-typed field? No, and even if the system let you do it, the performance would probably suck. Composite-type fields are not something to be used with abandon. To me your example looks like a design pattern to avoid. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general