Re: Need to check each element of an array satisfies a foreign key constraint

On Tue, Jul 13, 2021 at 7:47 AM David Gauthier <davegauthierpg(at)gmail(dot)com>
wrote:

> Ok, thanks.
>
> I was looking for, but didn't find, something like...
> each_element_of(regexp_split_to_array(children_csv)) references
> projects(project);
> Of course the "each_element_of" is my creation here :-)
>
>
Several years ago, I had hopes for this, and still do. It would be great
for my use cases. From what I remember, it was "complicated." There was a
patch proposed at least as far back as 9.3 for this[1]. Googling for
this now though, I see there was some activity on it this year[2]. Does
anyone know the status of this, or if/when this is likely to show up in
Postgresql? Thanks!

Ken

1.
https://www.2ndquadrant.com/en/blog/postgresql-9-3-development-array-element-foreign-keys/

2.
https://www.postgresql-archive.org/GSoC-2017-Foreign-Key-Arrays-td5962835i140.html

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.