On Tue, 4 May 2004, BRINER Cedric wrote: > CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE /table_name/ ( > { /column_name/ /data_type/ [ DEFAULT /default_expr/ ] [ /column_constraint/ [, ... ] ] > | /table_constraint/ } [, ... ] > ) > [ INHERITS ( /parent_table/ [, ... ] ) ] > [ WITH OIDS | WITHOUT OIDS ] What version are you doing this on? 7.4 seems to not have a comma there. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match