Belka Lambda <lambda-belka@yandex.ru> 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