Hi all. Can anyone help me solve this problem ? Say I have something like this:
CREATE TEMP TABLE idx (id integer, p integer, idd integer); INSERT INTO idx (id, p, idd) VALUES (3048, 1, 12043); INSERT INTO idx (id, p, idd) VALUES (3048, 2, 2321); INSERT INTO idx (id, p, idd) VALUES (3048, 5, 12002); INSERT INTO idx (id, p, idd) VALUES (3048, 6, 2387); INSERT INTO idx (id, p, idd) VALUES (3048, 13, 4301); INSERT INTO idx (id, p, idd) VALUES (3048, 16, 1022); INSERT INTO idx (id, p, idd) VALUES (3048, 19, 321); INSERT INTO idx (id, p, idd) VALUES (3049, 2, 7543); INSERT INTO idx (id, p, idd) VALUES (3050, 1, 56324); INSERT INTO idx (id, p, idd) VALUES (3050, 2, 8746); How do I put (SELECT * FROM idx) into multidimensional array variable ? (plpgsql) Is is possible at all ? regards mk
