The CREATE TABLE synopsis shows this: CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( { column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ] | table_constraint | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] } [, ... ] )
However, we now allow zero-column tables, so it should actually be CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name ( [ column_name data_type [ DEFAULT default_expr ] [ column_constraint [ ... ] ] | table_constraint | LIKE parent_table [ { INCLUDING | EXCLUDING } DEFAULTS ] ] [, ... ] ) Right? -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster