Tom Lane wrote: > raf <r...@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
hi tom, i had read the manual and the end of my original message said what you've just said followed by a request for this non-orthogonality in plpgsql to be fixed. i'm just repeating myself in case you responded without reading that part of the message (busy man that you are). no doubt it's a low priority thing but not allowing array elements here is hardly a desirable thing. cheers, raf -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
