DROP TABLE IF EXISTS FKTABLEFORARRAY;
CREATE TABLE FKTABLEFORARRAY (ftest1 int PRIMARY KEY, ftest2 int[]);
ALTER TABLE FKTABLEFORARRAY ADD CONSTRAINT FKARRAY FOREIGN KEY (EACH ELEMENT OF ftest2) REFERENCES PKTABLEFORARRAY;
CREATE INDEX ON FKTABLEFORARRAY USING gin (ftest2 array_ops);
INSERT INTO FKTABLEFORARRAY VALUES (1, '{632, 238, 775}');
INSERT INTO FKTABLEFORARRAY VALUES (2, '{488, 382, 160}');
INSERT INTO FKTABLEFORARRAY VALUES (3, '{977, 514, 523, 155}');
INSERT INTO FKTABLEFORARRAY VALUES (4, '{465, 53, 246, 119}');
INSERT INTO FKTABLEFORARRAY VALUES (5, '{115, 83, 411, 189}');
INSERT INTO FKTABLEFORARRAY VALUES (6, '{474, 571, 269, 47}');
INSERT INTO FKTABLEFORARRAY VALUES (7, '{80, 840, 494}');
INSERT INTO FKTABLEFORARRAY VALUES (8, '{588, 270, 114, 278, 927}');
INSERT INTO FKTABLEFORARRAY VALUES (9, '{104, 898}');
INSERT INTO FKTABLEFORARRAY VALUES (10, '{706, 655, 604, 318, 863}');
INSERT INTO FKTABLEFORARRAY VALUES (11, '{800, 388, 426, 140, 276}');
INSERT INTO FKTABLEFORARRAY VALUES (12, '{233}');
INSERT INTO FKTABLEFORARRAY VALUES (13, '{101, 204, 308, 888, 414}');
INSERT INTO FKTABLEFORARRAY VALUES (14, '{169, 828, 934, 57}');
INSERT INTO FKTABLEFORARRAY VALUES (15, '{385, 940}');
INSERT INTO FKTABLEFORARRAY VALUES (16, '{771, 403}');
INSERT INTO FKTABLEFORARRAY VALUES (17, '{617}');
INSERT INTO FKTABLEFORARRAY VALUES (18, '{596}');
INSERT INTO FKTABLEFORARRAY VALUES (19, '{664, 318, 206}');
INSERT INTO FKTABLEFORARRAY VALUES (20, '{214}');
INSERT INTO FKTABLEFORARRAY VALUES (21, '{247, 727}');
INSERT INTO FKTABLEFORARRAY VALUES (22, '{96, 571, 675, 432}');
INSERT INTO FKTABLEFORARRAY VALUES (23, '{234, 711, 623}');
INSERT INTO FKTABLEFORARRAY VALUES (24, '{354, 268, 589, 205, 630}');
INSERT INTO FKTABLEFORARRAY VALUES (25, '{576, 425}');
INSERT INTO FKTABLEFORARRAY VALUES (26, '{205, 778, 709, 326}');
INSERT INTO FKTABLEFORARRAY VALUES (27, '{896, 994, 314, 282, 476}');
INSERT INTO FKTABLEFORARRAY VALUES (28, '{673, 409}');
INSERT INTO FKTABLEFORARRAY VALUES (29, '{337}');
INSERT INTO FKTABLEFORARRAY VALUES (30, '{891}');
INSERT INTO FKTABLEFORARRAY VALUES (31, '{104, 257, 829, 405}');
INSERT INTO FKTABLEFORARRAY VALUES (32, '{623}');
INSERT INTO FKTABLEFORARRAY VALUES (33, '{668, 740}');
INSERT INTO FKTABLEFORARRAY VALUES (34, '{978, 579, 125, 502}');
INSERT INTO FKTABLEFORARRAY VALUES (35, '{383}');
INSERT INTO FKTABLEFORARRAY VALUES (36, '{968, 355, 854, 783}');
INSERT INTO FKTABLEFORARRAY VALUES (37, '{899}');
INSERT INTO FKTABLEFORARRAY VALUES (38, '{403}');
INSERT INTO FKTABLEFORARRAY VALUES (39, '{768, 975, 727, 472, 922}');
INSERT INTO FKTABLEFORARRAY VALUES (40, '{82, 988, 646}');
INSERT INTO FKTABLEFORARRAY VALUES (41, '{738, 330, 883, 467, 438}');
INSERT INTO FKTABLEFORARRAY VALUES (42, '{480, 994, 774, 683, 337}');
INSERT INTO FKTABLEFORARRAY VALUES (43, '{701}');
INSERT INTO FKTABLEFORARRAY VALUES (44, '{643, 392, 345, 601, 446}');
INSERT INTO FKTABLEFORARRAY VALUES (45, '{697, 397, 590}');
INSERT INTO FKTABLEFORARRAY VALUES (46, '{640, 5, 974, 860, 94}');
INSERT INTO FKTABLEFORARRAY VALUES (47, '{544}');
INSERT INTO FKTABLEFORARRAY VALUES (48, '{711, 468, 165, 695}');
INSERT INTO FKTABLEFORARRAY VALUES (49, '{65, 826, 339}');
INSERT INTO FKTABLEFORARRAY VALUES (50, '{526, 689, 915, 826, 923}');
INSERT INTO FKTABLEFORARRAY VALUES (51, '{552, 919}');
INSERT INTO FKTABLEFORARRAY VALUES (52, '{916, 21}');
INSERT INTO FKTABLEFORARRAY VALUES (53, '{587}');
INSERT INTO FKTABLEFORARRAY VALUES (54, '{523}');
INSERT INTO FKTABLEFORARRAY VALUES (55, '{48, 371, 111}');
INSERT INTO FKTABLEFORARRAY VALUES (56, '{112, 1, 976, 712}');
INSERT INTO FKTABLEFORARRAY VALUES (57, '{430}');
INSERT INTO FKTABLEFORARRAY VALUES (58, '{280, 956, 621, 655}');
INSERT INTO FKTABLEFORARRAY VALUES (59, '{364, 593, 245, 470, 569}');
INSERT INTO FKTABLEFORARRAY VALUES (60, '{18}');
INSERT INTO FKTABLEFORARRAY VALUES (61, '{504, 288, 231}');
INSERT INTO FKTABLEFORARRAY VALUES (62, '{496, 627, 37, 243}');
INSERT INTO FKTABLEFORARRAY VALUES (63, '{608, 362, 203, 596, 440}');
INSERT INTO FKTABLEFORARRAY VALUES (64, '{472, 894, 124, 486}');
INSERT INTO FKTABLEFORARRAY VALUES (65, '{232, 79, 564, 120, 415}');
INSERT INTO FKTABLEFORARRAY VALUES (66, '{416, 84, 916, 185, 188}');
INSERT INTO FKTABLEFORARRAY VALUES (67, '{306, 634, 567}');
INSERT INTO FKTABLEFORARRAY VALUES (68, '{881, 594, 17, 404, 376}');
INSERT INTO FKTABLEFORARRAY VALUES (69, '{976, 521, 734, 503}');
INSERT INTO FKTABLEFORARRAY VALUES (70, '{870, 41, 816, 561, 893}');
INSERT INTO FKTABLEFORARRAY VALUES (71, '{625}');
INSERT INTO FKTABLEFORARRAY VALUES (72, '{788}');
INSERT INTO FKTABLEFORARRAY VALUES (73, '{344, 960}');
INSERT INTO FKTABLEFORARRAY VALUES (74, '{240}');
INSERT INTO FKTABLEFORARRAY VALUES (75, '{398, 781, 246, 30}');
INSERT INTO FKTABLEFORARRAY VALUES (76, '{450, 547, 388, 219}');
INSERT INTO FKTABLEFORARRAY VALUES (77, '{872, 721}');
INSERT INTO FKTABLEFORARRAY VALUES (78, '{617, 130, 570}');
INSERT INTO FKTABLEFORARRAY VALUES (79, '{50, 412, 485}');
INSERT INTO FKTABLEFORARRAY VALUES (80, '{348, 86}');
INSERT INTO FKTABLEFORARRAY VALUES (81, '{882, 499, 76, 82}');
INSERT INTO FKTABLEFORARRAY VALUES (82, '{882, 445}');
INSERT INTO FKTABLEFORARRAY VALUES (83, '{582, 629, 85, 358}');
INSERT INTO FKTABLEFORARRAY VALUES (84, '{832, 676}');
INSERT INTO FKTABLEFORARRAY VALUES (85, '{99, 836, 202, 693, 471}');
INSERT INTO FKTABLEFORARRAY VALUES (86, '{52}');
INSERT INTO FKTABLEFORARRAY VALUES (87, '{97, 70, 6, 911, 272}');
INSERT INTO FKTABLEFORARRAY VALUES (88, '{289, 76, 430}');
INSERT INTO FKTABLEFORARRAY VALUES (89, '{960}');
INSERT INTO FKTABLEFORARRAY VALUES (90, '{759}');
INSERT INTO FKTABLEFORARRAY VALUES (91, '{289, 326, 533, 341, 117}');
INSERT INTO FKTABLEFORARRAY VALUES (92, '{240, 929, 740}');
INSERT INTO FKTABLEFORARRAY VALUES (93, '{642, 39, 173, 813, 574}');
INSERT INTO FKTABLEFORARRAY VALUES (94, '{200, 66, 820}');
INSERT INTO FKTABLEFORARRAY VALUES (95, '{794, 179}');
INSERT INTO FKTABLEFORARRAY VALUES (96, '{376, 379, 701}');
INSERT INTO FKTABLEFORARRAY VALUES (97, '{576, 40, 777, 975, 25}');
INSERT INTO FKTABLEFORARRAY VALUES (98, '{580, 9, 244, 666, 543}');
INSERT INTO FKTABLEFORARRAY VALUES (99, '{906, 788, 951, 506, 414}');
INSERT INTO FKTABLEFORARRAY VALUES (100, '{897, 165, 871, 973, 889}');
