[GENERAL] self referenced table ?

Hi, how can we do this ? CREATE TABLE test (key1 int, key2 int , primary key (key1,key2), parent constraint parent references test ); Cédric BRINER ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archi

[GENERAL] pgsql documentation error ?

Synopsis 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 ] so this means that every

[GENERAL] create synopsis wrong ?

Synopsis 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 ] .. .. so this will mean