Re: array in a reference - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: array in a reference
Date
Msg-id 20030507085300.R26747-100000@megazone23.bigpanda.com
Whole thread Raw
In response to array in a reference  ("Ries van Twisk" <ries@jongert.nl>)
List pgsql-sql
On Wed, 7 May 2003, Ries van Twisk wrote:

>
> 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????

Not in this case, it's going to want to compare the entire array to the
id (and will probably fail saying that there's no = operator for _int4 and
int4).



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Date Anomaly??
Next
From: mdc@keko.com.ar
Date:
Subject: help database corruption