On Fri, Mar 28, 2014 at 12:45 PM, <hari.fuchs@xxxxxxxxx> wrote:
> I want to ensure that for any given value of fk_col that there is a maximumThis should be what you want:
> of one row with bool_col = true.
ALTER TABLE exclusion_example
ADD CONSTRAINT ex
EXCLUDE (fk_col WITH =) WHERE (bool_col);
Yes, that would do the trick!
I think I'll just set up a partial unique index as per Igor's suggestion, however.
Thank you!
Moshe Jacobson
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
