Re: [GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Henry M
/docs/9.6/static/sql-createtrigger.html that postgresql uses triggers to implement foreign keys so I am probably just missing the syntactic sugar for arrays. I will try to use a trigger. Thank you. On Wed, Apr 19, 2017 at 12:24 PM Rob Sargent wrote: > > > On 04/19/2017 01:13 PM, Henr

[GENERAL] referential integrity between elements of an array and another table?

2017-04-19 Thread Henry M
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: https