IMO, both approaches make sense...
From temporal point no doubt, referencing should be contained by
referenced table....
From other side could be useful if in master table are elements with
simple data type, but for some set of elements there could be common
properties in another table.. What today is doable on the way to in
another table have the same data type and repeat the same properties
for each element...That would be possible with Range data type, though
it does not mean always data are in range so array is probably better
option...
However I am not sure from maintaining point of view, i,e when an
element should be removed from that common properties set - but it is
different topic :)
Kind Regards,
Misa
Sent from my Windows Phone
-----Original Message-----
From: Jeff Davis
Sent: 17/06/2012 08:55
To: Gabriele Bartolini
Cc: PostgreSQL-development; Marco Nenciarini
Subject: Re: [HACKERS] [PATCH] Support for foreign keys with arrays