Error in the 9.1 documentation?

Thomas Kellerer <spam_eater@xxxxxxx> · Sat, 07 May 2011 16:24:11 +0200

Hi,

while going through the 9.1 new features, I think I have discovered an error in the manual regarding the CREATE TABLE command.

It says:

CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name ( [
  { column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]
    | table_constraint
    | LIKE parent_table [ like_option ... ] }
    [, ... ]

Isn't there the element for DEFAULT missing for the column definition?

Something like:

column_name data_type [ DEFAULT default_expr ] [ COLLATE collation ] [ column_constraint [ ... ] ]

Regards
Thomas

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general