Re: Error in column constraint syntax

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Error in column constraint syntax
Date: 2016-12-27 17:30:36
Message-ID: alpine.LNX.2.11.1612270918270.8904@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Арсен Арутюнян 2016-12-27 18:05:06 Indexes and loops
Previous Message David G. Johnston 2016-12-27 16:53:34 Re: Error in column constraint syntax