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