Received: from parmastocks2.cylink.com.cy (parmastocks2.cylink.com.cy [194.42.142.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f78HRD630886 for ; Wed, 8 Aug 2001 13:27:14 -0400 (EDT) (envelope-from grigoriy.vovk@linustech.com.cy) Received: from [192.168.1.2] (parmastocks.cylink.com.cy [194.42.135.92]) by parmastocks2.cylink.com.cy (Postfix) with ESMTP id 2156934080; Wed, 8 Aug 2001 20:23:11 +0300 (EEST) Date: Wed, 8 Aug 2001 20:26:33 +0300 (EEST) From: "Grigoriy G. Vovk" X-X-Sender: To: Cedar Cox Cc: Subject: Re: REFERENCES constraint In-Reply-To: Message-ID: <20010808202427.Q574-100000@callisto.internal.linustech.com.cy> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200108/131 X-Sequence-Number: 4352 As for me it is looking as not good normalized structure. After normalization should not be any questions, I think... Aug 8, 19:02 +0300, Cedar Cox wrote: > > Two questions (maybe they are silly..) > > 1. Can a column reference more than one table? (This assumes you use a > single sequence to generate the IDs for both "tbla" and "tblb". I guess > you would also have the problem of enforcing a unique index. Say what?! > A unique index across multiple tables.. absurd :) eg.. > > CREATE TABLE blah ( > id int4, > f_id int4 REFERENCES tbla (id) REFERENCES tblb (id) > ) > > 2. Can a column reference another column in the same table? eg.. > > CREATE TABLE bloo ( > id int4, > p_id int4 REFERENCES bloo (id) > -- or > --p_id int4 REFERENCES (id) > ) > > I'm guessing the answer is no, in which case I have to fall back to > writing custom PL/ functions and triggers. Just thought I'd ask anyway. > It would be nice if it were this easy though... > > -Cedar > p.s. please CC my on this thread.. I'm on vacation (on this list) :0 > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > my best regards, ---------------- Grigoriy G. Vovk