Horton
Menu

Re: operator exclusion constraints

Jeff Davis <pgsql@j-davis.com>

View thread
From: Jeff Davis <pgsql@j-davis.com>
To: "David E. Wheeler" <david@kineticode.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, Simon Riggs <simon@2ndquadrant.com>, pgsql-hackers@postgresql.org
Date: 2009-11-05T18:13:30Z
Lists: pgsql-hackers 
On Thu, 2009-11-05 at 09:25 -0800, David E. Wheeler wrote:
> CHECK is a verb; so what about a verb here?

CHECK -- verb or noun
UNIQUE -- adjective
PRIMARY KEY -- noun
FOREIGN KEY -- noun

Any of them can be called an adjective if you put it before the word
"constraint". But that's kind of circular: if we made a new type of
constraint and called it XYZ, we could say XYZ CONSTRAINT, and call XYZ
an adjective.

I'm having trouble finding a clear pattern to follow.

Regards,
	Jeff Davis