Обсуждение: self referenced table ?

Поиск
Список
Период
Сортировка

self referenced table ?

От
BRINER Cedric
Дата:
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


Re: self referenced table ?

От
Stephan Szabo
Дата:
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.