Re: The example for creating a check constraint is missing a comma

[Tom Lane]

=?utf-8?q?PG_Doc_comments_form?=  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,
> namevarchar(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

The example for creating a check constraint is missing a comma

[PG Doc comments form]

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/10/static/sql-createtable.html
Description:

See the example from the documentation for CREATE TABLE below. There should
be a comma before the CONSTRAINT keyword. 

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