Received: from server.beierfeld.kabeljournal.de (pD9508749.dip.t-dialin.net [217.80.135.73]) by postgresql.org (Postfix) with SMTP id 6422E4759D8 for ; Wed, 13 Mar 2002 05:51:02 -0500 (EST) Received: (qmail 31701 invoked from network); 13 Mar 2002 10:51:03 -0000 Received: from station158.beierfeld.kabeljournal.de (HELO km3.de) (192.168.128.158) by server.beierfeld.kabeljournal.de with SMTP; 13 Mar 2002 10:51:03 -0000 Message-ID: <3C8F2FA9.EF9C2710@km3.de> Date: Wed, 13 Mar 2002 11:53:29 +0100 From: Andre Schubert X-Mailer: Mozilla 4.77 [de] (X11; U; Linux 2.2.19-6.2.12 i586) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: REFERENCES Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/131 X-Sequence-Number: 7011 Hi to all, i have a simple problem and wont request assistance fro m this list. i have to tables foo: id int8 UNIQUE bar: id int8 UNIQUE foo_id int8 Now i wont foo_id to be a id which exists in the foo, this could be done with foo_id REFERENCES foo (id). But what should i do if i want foo_id to be a id existing in foo or to be zero(0). I have created a view as "select id from foo UNION select 0" and tried to REFERENCE against this view, but that doesnt work. Can this problem be solved by a somebody ???? Thanks -- Andre Schubert EMail: Andre.Schubert@km3.de Tel: 03774 6625-78 km3 teledienst GmbH Fax: 03774 6625-79