On Fri, Mar 28, 2014 at 12:21 PM, Igor Neyman <iney...@perceptron.com>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. <http://www.neadwerx.com> 2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339 "Quality is not an act, it is a habit." -- Aristotle
