On Fri, Mar 28, 2014 at 12:45 PM, <hari.fu...@gmail.com> wrote: > > I want to ensure that for any given value of fk_col that there is a > maximum > > of one row with bool_col = true. > > This should be what you want: > > 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 Manager of Systems Engineering, Nead Werx Inc. <http://www.neadwerx.com> 2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339 "Quality is not an act, it is a habit." -- Aristotle