Re: [HACKERS] Not In Foreign Key Constraint

2013-09-19 Thread David Johnston
Misa Simic wrote > Hi hackers, > > I just wonder how hard would be to implement something like "Not In FK > Constraint" or opposite to FK... A more useful couple next sentences would be along the lines of: I have this problemI've approached it by doingbut it seems that an actual database

Re: [HACKERS] Not In Foreign Key Constraint

2013-09-19 Thread Misa Simic
2013/9/19 David Johnston > Misa Simic wrote > > I guess that rule can be achieved with triigers on TableA and TableC - > but > > the same is true for FK (and FK constraint is more effective then trigger > > - > > that is why I wonder would it be useful/achievable to create that kind of > > constr

Re: [HACKERS] Not In Foreign Key Constraint

2013-09-18 Thread David Johnston
Misa Simic wrote > I guess that rule can be achieved with triigers on TableA and TableC - but > the same is true for FK (and FK constraint is more effective then trigger > - > that is why I wonder would it be useful/achievable to create that kind of > constraint) > > Thoughts, ideas? You create a

Re: [HACKERS] Not In Foreign Key Constraint

2013-09-18 Thread Jim Nasby
On 9/16/13 6:16 AM, Misa Simic wrote: Hi hackers, I just wonder how hard would be to implement something like "Not In FK Constraint" or opposite to FK... i.e: FK ensures that value of FK column of inserted row exists in refferenced Table NotInFK should ensure that value of NotInFK colum

[HACKERS] Not In Foreign Key Constraint

2013-09-16 Thread Misa Simic
Hi hackers, I just wonder how hard would be to implement something like "Not In FK Constraint" or opposite to FK... i.e: FK ensures that value of FK column of inserted row exists in refferenced Table NotInFK should ensure that value of NotInFK column of inserted row does not Exist in referen