X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C4B014763B5 for ; Wed, 7 May 2003 11:08:25 -0400 (EDT) Received: from sv003.int.jongert.nl (jongert.nl [194.109.59.87]) by postgresql.org (Postfix) with ESMTP id 66B944764B5 for ; Wed, 7 May 2003 11:07:55 -0400 (EDT) Received: from IT001 (IT001.int.jongert.nl [10.0.0.241]) by sv003.int.jongert.nl (Postfix) with SMTP id 073F399 for ; Wed, 7 May 2003 17:07:58 +0200 (CEST) From: "Ries van Twisk" To: Subject: array in a reference Date: Wed, 7 May 2003 17:07:55 +0200 Message-ID: <000b01c314aa$70f58400$f100000a@IT001> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) x-mimeole: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Spam-Status: No, hits=-2.5 required=5.0 tests=BAYES_20,UPPERCASE_25_50 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/125 X-Sequence-Number: 13290 Hey Guys, I was just wondering if it is possible to use a REFERENCE in a array like this below: CREATE TABLE t0 { id SERIAL, value TEXT } CREATE TABLE t1 { id SERIAL, t0id INTEGER[] REFERENCES t0(id) -- <<<< Is this possible???? } regards, Ries van Twisk