From: Tom Lane <tgl@sss.pgh.pa.us>
To: neil@postgrescompare.com
cc: pgsql-docs@lists.postgresql.org
Subject: Re: The example for creating a check constraint is missing a comma
In-reply-to: <151871659877.1393.2431103178451978795@wrigleys.postgresql.org>
References: <151871659877.1393.2431103178451978795@wrigleys.postgresql.org>
Comments: In-reply-to =?utf-8?q?PG_Doc_comments_form?=
 <noreply@postgresql.org>
	message dated "Thu, 15 Feb 2018 17:43:18 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <27716.1518720459.1@sss.pgh.pa.us>
Date: Thu, 15 Feb 2018 13:47:39 -0500
Message-ID: <27717.1518720459@sss.pgh.pa.us>
Precedence: bulk

=?utf-8?q?PG_Doc_comments_form?= <noreply@postgresql.org> writes:
> See the example from the documentation for CREATE TABLE below. There should
> be a comma before the CONSTRAINT keyword. 

> CREATE TABLE distributors (
>     did     integer,
>     name    varchar(40)
>     CONSTRAINT con1 CHECK (did > 100 AND name <> '')
> );

Hmm ... that example is legal syntax as-is, but considering that the
explanation for it says specifically that it's table-constraint syntax
not column-constraint syntax, I think you're right.

			regards, tom lane