On 7 May 2011 15:24, Thomas Kellerer <spam_eater@gmx.net> wrote:
> 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 [ ... ] ]
The DEFAULT declaration was moved into the column_constraint section.
--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company