Re: [SQL] Having elements of an int[]-array reference other tables

2008-01-21 Thread Pavel Stehule
Hello, it isn't possible without custom triggers. regards Pavel Stehule On 21/01/2008, Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote: > Hi. > Is it possible in PG to have elements in an int[]-array reference another > int-column in another table? What I want is it to behave as a foreign key.

[SQL] Having elements of an int[]-array reference other tables

2008-01-21 Thread Andreas Joseph Krogh
Hi. Is it possible in PG to have elements in an int[]-array reference another int-column in another table? What I want is it to behave as a foreign key. create table master( my_id integer primary key ); create table test( id serial primary key, id_array integer[] references master(my_id) ); It