Re: operator exclusion constraints - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: operator exclusion constraints
Date
Msg-id 5F36EF5F-0283-4583-8CF0-783A0DEE46DB@kineticode.com
Whole thread Raw
In response to Re: operator exclusion constraints  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: operator exclusion constraints
List pgsql-hackers
On Nov 13, 2009, at 8:39 PM, Robert Haas wrote:

> alter table foo add constraint bar exclude (a check with =, b check with =);

I've been meaning to comment on this syntax one more time; apologies for the bike-shedding. But I'm wondering if the
"CHECK"is strictly necessary there, since the WITH seems adequate, and there was some discussion before about the CHECK
keywordpossibly causing confusion with check constraints. 

Best,

David



pgsql-hackers by date:

Previous
From: Robert Hodges
Date:
Subject: Re: Hot standby, overflowed snapshots, testing
Next
From: Tom Lane
Date:
Subject: Re: operator exclusion constraints