Re: [GENERAL] Questions concerning check constraints

2007-11-02 Thread hubert depesz lubaczewski
On Fri, Nov 02, 2007 at 10:04:06AM +0100, Christian Rengstl wrote: > 1) Is it possible to refer to a column in a different table, ie > entering a value in mytable.x should only be allowed if mytable2.y=1 for > example? I know that it is possible to use triggers to do that, but I > think adding a si

[GENERAL] Questions concerning check constraints

2007-11-02 Thread Christian Rengstl
Hi list, I have two question concerning check constraints: 1) Is it possible to refer to a column in a different table, ie entering a value in mytable.x should only be allowed if mytable2.y=1 for example? I know that it is possible to use triggers to do that, but I think adding a simple check cons