Обсуждение: setting foreigh key for an array.

I have a requirement.

Created table called a.
CREATE TABLE a(no int primary key,name text);


Need to create reference key for no field of array. which is belongs to b
table.
The postgresql is not allowing to create a reference for incompatible type.

CREATE TABLE d(no int[] references a,name text);
ERROR:  foreign key constraint "d_no_fkey" cannot be implemented
DETAIL:  Key columns "no" and "no" are of incompatible types: integer[] and
integer.

Is there any solution to setting foreign key for an array.

NOTE:
        Kindly ensure that I don't want to change the int to int[] in a
table.

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/setting-foreigh-key-for-an-array-tp3384264p3384264.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

You write trigger for integrity

--
------------
pasman