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

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Tuesday, July 13, 2021, David Gauthier <davegauthierpg(at)gmail(dot)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.
>
>