Re: [PATCH] Support for foreign keys with arrays - Mailing list pgsql-hackers

From Misa Simic
Subject Re: [PATCH] Support for foreign keys with arrays
Date
Msg-id CAH3i69kQ3vi0EiP32Eid-7V3r2HTW4OtekNjzsDRPE4MBR2v7w@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Support for foreign keys with arrays  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: [PATCH] Support for foreign keys with arrays  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers

2012/6/17 Kevin Grittner <Kevin.Grittner@wicourts.gov>


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?
 

I can't imagine either other usablity... Just many-to-one linkage... or to have many-to-many link with less rows in middle table... What is better - I think should be measured...

pgsql-hackers by date:

Previous
From: Misa Simic
Date:
Subject: Re: [PATCH] Support for foreign keys with arrays
Next
From: Peter Geoghegan
Date:
Subject: Re: sortsupport for text