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.
