Re: Array of foreign key

On 2017-12-23 13:14:50 -0500, Melvin Davidson wrote:
> On Sat, Dec 23, 2017 at 12:49 PM, Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> wrote:
>
> I thought the OP was asking for this feature ("Support for Array ELEMENT
> Foreign Keys"):
>
> https://www.postgresql.org/message-id/flat/1343842863.
> 5162(dot)4(dot)camel(at)greygoo(dot)devise-it(dot)lan#1343842863(dot)5162(dot)4(dot)
> camel(at)greygoo(dot)devise-it(dot)lan 
>
> which would be super-handy, but doesn't actually exist.  You can enforce it
> yourself with a trigger on both tables, but I still hope this someday gets
> included into Postgres!
>
> Actually, I think the op may be referring to a MULTI COLUMN FK array

I see no reason to assume that. He explicitely asked about an array of
foreign keys, and there is no array here.

hp

--
_ | Peter J. Holzer | we build much bigger, better disasters now
|_|_) | | because we have much more sophisticated
| | | hjp(at)hjp(dot)at | management tools.
__/ | http://www.hjp.at/ | -- Ross Anderson <https://www.edge.org/>