Re: [SQL] array variables

[Marcin Krawczyk]

I know I can do one column like this :

a := ARRAY(SELECT id FROM idx);

but how about more than one ?
Because if I try this :

a := ARRAY(SELECT id, p FROM idx);

I get
ERROR: subquery must return only one column
SQL state: 42601

regards
mk