On Fri, Mar 28, 2014 at 12:21 PM, Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote:
For this:
"any given value of fk_col that there is a maximum of one row with bool_col = true."why don't you (instead) create partial unique index:
CREATE UNIQUE INDEX on exclusion_example(fk_col, bool_col) WHERE bool_col IS TRUE;
Ahh yes, why didn't I think of that? Thank you.
Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339
"Quality is not an act, it is a habit." -- Aristotle
"Quality is not an act, it is a habit." -- Aristotle
