Re: [GENERAL] Error in column constraint syntax - Mailing list pgsql-general

On Tue, 27 Dec 2016, David G. Johnston wrote:

> ​5.3.1 is instructional.  The SQL Command chapter is the
> authoritative source for syntax.

David,

   I'll read that, too.

> CHECK ( expression ) [ NO INHERIT ] |   -- you are missing the mandatory (
> ) surrounding your expression
> All of the examples in 5.3.1 have a "(" following the word CHECK as well...

   Yes, I see now that I misplaced the opening parenthesis and missed the
second closing parenthesis at the end of the IN list.

   I thought I had tested this syntax; obviously I did not.

Thanks,

Rich