execute - Mailing list pgsql-sql

From Mauricio Cruz
Subject execute
Date
Msg-id 38dac89ce680b4e50ba69e2851cb6f60@sygecom.com.br
Whole thread Raw
Responses Re: execute  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-sql

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 should not use "execute" besides of  insert, update, delete ...  but how could I do in this case ?

 

Thanks every one.

 

-- 
Grato,
Mauricio Cruz
Sygecom Informática
51 3442-3975 / 3442-2345 

pgsql-sql by date:

Previous
From: shabeer ece
Date:
Subject: Not Able to Delink the old tables
Next
From: Sergey Konoplev
Date:
Subject: Re: execute