From: Mauricio Cruz <cruz@sygecom.com.br>
To: pgsql-sql@postgresql.org
Subject: execute
Date: Thu, 25 Apr 2013 13:17:06 -0300
Message-ID: <38dac89ce680b4e50ba69e2851cb6f60@sygecom.com.br> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
[1]
51 3442-3975 / 3442-2345
Links:
------
[1]
http://www.sygecom.com.br
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cruz@sygecom.com.br
Subject: Re: execute
In-Reply-To: <38dac89ce680b4e50ba69e2851cb6f60@sygecom.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox