self referenced table ?

From: BRINER Cedric <work(at)infomaniak(dot)ch>
To: postgres <pgsql-general(at)postgresql(dot)org>
Subject: self referenced table ?
Date: 2004-03-19 14:19:00
Message-ID: 405B0154.7000706@infomaniak.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Bernier 2004-03-19 14:21:54 another postgres article
Previous Message David Garamond 2004-03-19 13:21:12 sequential scan when using bigint value