Postgres Pro
Downloads
Home   >   mailing lists

self referenced table ? - Mailing list pgsql-general

From BRINER Cedric
Subject self referenced table ?
Date
Msg-id 405B0154.7000706@infomaniak.ch
Whole thread Raw
Responses Re: self referenced table ?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: sequential scan when using bigint value
Next
From: Francisco Reyes
Date:
Subject: Re: Huge number of raws