Simon Riggs wrote:
Misa Simic wrote:
>> IMO, both approaches make sense...
>
> Agreed.
Can someone provide a practical example of a "foreign key with array"
use case? The only situations I'm able to think of right now are the
same cases where you would now use a table with primary keys of two
tables to provide a many-to-many linkage. Does this proposed feature
handle other cases or handle this type of case better?
The "referencing value is contained by the referenced value" has many
obvious uses. For example, in our courts data we have a statute
table which effectively has a statute cite and effective date range
for the primary key, and we have a charge table with a statute cite
and an offense date used to match it to a statute row.
-Kevin