diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2002-12-16 19:08:25 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2002-12-16 19:08:25 +0000 |
| commit | 9cecff0314c3c75248f29fea6b80c19d9a8a8c70 (patch) | |
| tree | e1f2bd0cb5cc9e438f0c0f783500d8862d3651ad /doc/src/sgml/ref/create_table.sgml | |
| parent | 5131e5ab7d75279fe78d025f6d6668f15d7efd67 (diff) | |
| download | postgresql-9cecff0314c3c75248f29fea6b80c19d9a8a8c70.tar.gz | |
Document that zero-column tables are allowed (and non-standard).
Diffstat (limited to 'doc/src/sgml/ref/create_table.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 6d67f22a6b..db51a26469 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.59 2002/11/21 23:34:43 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/create_table.sgml,v 1.60 2002/12/16 19:08:25 tgl Exp $ PostgreSQL documentation --> @@ -915,6 +915,19 @@ CREATE ASSERTION <replaceable>name</replaceable> CHECK ( <replaceable>condition< standard. </para> </refsect2> + + <refsect2> + <title>Zero-column tables</title> + + <para> + <productname>PostgreSQL</productname> allows a table of no columns + to be created (for example, <literal>CREATE TABLE foo();</>). This + is an extension from the SQL standard, which does not allow zero-column + tables. Zero-column tables are not in themselves very useful, but + disallowing them creates odd special cases for <command>ALTER TABLE + DROP COLUMN</>, so it seems cleaner to ignore this spec restriction. + </para> + </refsect2> </refsect1> |