Re: [GENERAL] referential integrity between elements of an array andanother table? - Mailing list pgsql-general

From Rob Sargent
Subject Re: [GENERAL] referential integrity between elements of an array andanother table?
Date
Msg-id 776a0fe3-f72c-d6a7-2958-7698342a45de@gmail.com
Whole thread Raw
In response to [GENERAL] referential integrity between elements of an array and another table?  (Henry M <henrymanmail@gmail.com>)
List pgsql-general



On 04/19/2017 01:13 PM, Henry M wrote:
I was just reading this question on reddit (the text duplicated below). I was wondering if there is an approach for handling array foreign key references. I am interested in the answer since I started using array fields as well. Thank you.


----- below is the message from the reddit poster:

Unless you have thousands of attendees per meeting and everyone in multiple meetings per day I would encourage a join table.  What's your hesitation for doing so?  Note I'm an array user myself, so not against arrays per se, but there should be a justification for denormalizing (depending your definition thereof).

pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: [GENERAL] referential integrity between elements of an array andanother table?
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] referential integrity between elements of an array andanother table?