[Solved] Setting a multifield constraint

gkick · Post by **gkick** » Sat Sep 05, 2020 6:46 pm

Hi,

How does one set a multi field constraint like
if debit is greater then 0 then credit is 0 and if credit is greater then 0 then debit is 0

Thanks

edit this topic's initial post · Post by **Villeroy** » Sat Sep 05, 2020 7:53 pm

Code: Select all

alter table "foo" add constraint "blah" check "debit"=0 OR "credit"=0

gkick · Post by **gkick** » Sat Sep 05, 2020 9:34 pm

Thank you Villeroy

[Solved] Setting a multifield constraint

[Solved] Setting a multifield constraint

Re: Setting a multifield constraint

Re: Setting a multifield constraint