Re: Error in the 9.1 documentation?
От
Thom Brown
Тема
Re: Error in the 9.1 documentation?
Дата
Msg-id
BANLkTikUMqKf-GcD482EMnfTt7MSwfTx-g@mail.gmail.com
Ответ на
Error in the 9.1 documentation? (Thomas Kellerer)
Список
Дерево обсуждения
Error in the 9.1 documentation? Thomas Kellerer <spam_eater@gmx.net>
Re: Error in the 9.1 documentation? Thom Brown <thom@linux.com>
Re: Error in the 9.1 documentation? Thomas Kellerer <spam_eater@gmx.net>
On 7 May 2011 15:24, Thomas Kellerer 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
В списке pgsql-general по дате отправления
