[SQL] execute

2013-04-25 Thread Mauricio Cruz
Hi every one, I'm trying to do the follow: declare aCad text[][] begin ... execute 'aCad:=aCad array[['||var1||','||var2||']]' ... end; language plpgsql but I get the follow error: sintax erro near to "aCad" aCad := aCad || array[rCad.cmp,rSql.codfor] ^ I guess I sho

Re: [SQL] execute

2013-04-25 Thread Sergey Konoplev
On Thu, Apr 25, 2013 at 9:17 AM, Mauricio Cruz wrote: > execute 'aCad:=aCad array[['||var1||','||var2||']]' What are you going to do using this construction aCad:=aCad array[['||var1||','||var2||']] ? I can not understand the meaning. -- Kind regards, Sergey Konoplev Database and Software Con