Return to Answer

deleted 9 characters in body

Source Link

edited Aug 12, 2023 at 8:13

I agree with Jose that you are overcomplicating the problem. I think you can write a simple check constrainttrigger on the column you want the database to check its integrity. I mean something like

select ((select * from users where user_id = actor_id) or (select * from "groups" where group_id = actor_id))

I agree with Jose that you are overcomplicating the problem. I think you can write a simple check constraint on the column you want the database to check its integrity. I mean something like

select ((select * from users where user_id = actor_id) or (select * from "groups" where group_id = actor_id))

I agree with Jose that you are overcomplicating the problem. I think you can write a simple trigger on the column you want the database to check its integrity. I mean something like

select ((select * from users where user_id = actor_id) or (select * from "groups" where group_id = actor_id))

Source Link

created Aug 11, 2023 at 18:55

Sajjad

I agree with Jose that you are overcomplicating the problem. I think you can write a simple check constraint on the column you want the database to check its integrity. I mean something like

select ((select * from users where user_id = actor_id) or (select * from "groups" where group_id = actor_id))