Hi everyone! Is there a way to construct FOREIGN KEYs from parts of composite-typed field?
The code returns an error: ----------------------------------------- create table aaa ( a_id integer primary key, a_str varchar) ; create type content_of_bbb (a_id integer, b_str varchar); create table bbb ( b_id integer primary key, bbb_content content_of_bbb, foreign key (bbb_content.a_id) references aaa(a_id) ); ----------------------------------------- , so I suspect it's impossible. Is it? Belka -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
