Thread: self referenced table ?

Hi,

how can we do this ?

CREATE TABLE test (key1 int, key2 int , primary key (key1,key2), parent
  <?kind of data type?> constraint parent references test  );

Cédric BRINER

On Fri, 19 Mar 2004, BRINER Cedric wrote:

> CREATE TABLE test (key1 int, key2 int , primary key (key1,key2), parent
>   <?kind of data type?> constraint parent references test  );

Foreign keys must reference a unique value.  If the only uniqueness
constraint is (key1, key2) as above, then it requires two columns to do
the constraint (one holding the referenced key1 value, one holdign the
referenced key2 value) and a table level foreign key constraint or you
need something like a serial key added to the table.