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 getERROR: subquery must return only one columnSQL state: 42601
regardsmk