Re: [PATCH] Support for foreign keys with arrays

From: Misa Simic <misa(dot)simic(at)gmail(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: simon(at)2ndquadrant(dot)com, gabriele(dot)bartolini(at)2ndquadrant(dot)it, marco(dot)nenciarini(at)2ndquadrant(dot)it, pgsql(at)j-davis(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCH] Support for foreign keys with arrays
Date: 2012-06-17 15:25:16
Message-ID: CAH3i69kQ3vi0EiP32Eid-7V3r2HTW4OtekNjzsDRPE4MBR2v7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2012/6/17 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)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...

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2012-06-17 15:36:20 Re: sortsupport for text
Previous Message Misa Simic 2012-06-17 15:14:05 Re: [PATCH] Support for foreign keys with arrays