Horton
Menu

Re: operator exclusion constraints

Jeff Davis <pgsql@j-davis.com>

View thread
From: Jeff Davis <pgsql@j-davis.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, Simon Riggs <simon@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2009-11-06T23:03:35Z
Lists: pgsql-hackers 
On Fri, 2009-11-06 at 14:59 -0500, Tom Lane wrote:
> If we restrict this thing to being a table constraint, not a column
> constraint, it seems like the issue might go away (and in fact I think
> you might not even need col_name_keyword).

I never enabled the syntax for column constraints, so it was always a
part of ConstraintElem.

To make sure I understand what you're saying, you think that:

CREATE TABLE foo
(
  exclusion int,
  EXCLUSION (exclusion CHECK WITH =)
);

should work? It's not ambiguous, but I'm not an expert on the grammar,
so I don't immediately know a non-invasive way to express that.

Regards,
	Jeff Davis