I have two tables that i want to link with a FK where the child table record is "active".
some googling shows that i could use a function and a check constraint on the function, but that only works for inserts, not updates on table b. create table a (int id, text name); create table b (int id, boolean active); alter table a add column b_id integer; -- how to do this? alter table a add foreign key (b_id) references b(id) where b.active == true help :).
