Re: array in a reference

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).