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 :-)
On Tue, Jul 13, 2021 at 10:07 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tuesday, July 13, 2021, David Gauthier <davegauthie...@gmail.com> > wrote: >> >> >> I suppose I could write a stored procedure to do this and call it in a >> check constraint. But I was wondering if there is something more elegant. >> >> > You cannot use a check constraint here as the behavior is not immutable. > You can use a trigger function though. Or normalize the table and use the > built-it foreign key triggers. > > David J. > >
