From: | "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | array variables |
Date: | 2008-11-13 09:08:35 |
Message-ID: | 95f6bf9b0811130108l4041650es77a21674d825f43@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Marcin Krawczyk | 2008-11-13 09:13:30 | Re: array variables |
Previous Message | Helio Campos Mello de Andrade | 2008-11-12 22:14:09 | Invitation to connect on LinkedIn |