raf <raf@raf.org> writes:
> declare
> pay_group_rec pay_group;
> balance decimal(10,2)[];
> begin
> select g.* into pay_group_rec from pay_group g where g.id = pay_group_id;
> select
> sum(p.balance_period[1]),
> sum(p.balance_period[2])
> into
> balance[1],
> balance[2]
> from
> payee p
Sorry, you can't do that ... per the fine manual, the INTO target can be
"a record variable, a row variable, or a comma-separated list of simple
variables and record/row fields". Nothing there about array subscript
expressions.
regards, tom lane