On Tue, Jul 13, 2021 at 7:47 AM David Gauthier <davegauthie...@gmail.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.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
