Re: [GENERAL] Error in column constraint syntax

2016-12-27 Thread Rich Shepard
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

Re: [GENERAL] Error in column constraint syntax

2016-12-27 Thread David G. Johnston
On Tue, Dec 27, 2016 at 9:39 AM, Rich Shepard wrote: > I'm encountering DDL syntax errors using postgres-9.6.1 that I've not > before seen, and I'm having a difficult time finding the cause when reading > the appropriate sections of the manual; Section 5.3.1 in this case: > ​5.3.1 is instructi