execute

From: Mauricio Cruz <cruz(at)sygecom(dot)com(dot)br>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: execute
Date: 2013-04-25 16:17:06
Message-ID: 38dac89ce680b4e50ba69e2851cb6f60@sygecom.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
[1]
51 3442-3975 / 3442-2345

Links:
------
[1]
http://www.sygecom.com.br

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Sergey Konoplev 2013-04-26 00:21:21 Re: execute
Previous Message shabeer ece 2013-04-23 08:01:51 Not Able to Delink the old tables